I would like to use a macro to format my Excel sheet after running an export to Excel automation. Is there a way to include this macro in the automation?
Here is a video that explains how to use macros in automation.
Make sure to uncheck the ‘Add Date/Time suffix to filename’ option in the Export wizard. There is a defect that will not let the macro to run if this option is checked. See SOL75430: Issue with file extensions when including macro in an export to Excel automation for more information regarding the defect.
