Prior to version 4.0.1:
Manually create a new .xlsm file for the data to be saved to and select that file during the export to have the data exported to it.
Starting with version 4.0.1:
Toad will create a new .xlsm file if the 'Select To File' activity is being used during automation. The name of the file can be specified with the .xlsm extension.