Trying to include a macro in an export to Excel automation. The file that has been selected to export the data to has a .xlsm extension. However, when the automation is run, the file that the data is acutally saved to has a .xlsx extension. Because of the change of file extension, the macro does not run.
WORKAROUND:
None
STATUS:
Waiting for fix to be released in a future version of Toad for Data Analysts.
