I built an automation script using the export file. Selected the query to be executed, file type of excel. When I was prompted to save the file location, I mapped it back to an excel macro that had two macros. I saw the prompt to decide to execute the macros before or after the load. I select both to run after the load. I saved the template and ran the automation script. When I tried to open the file I received this message
Excel can not open the file becuase the file or extension is not valid.
Any suggestions what is wrong or if I am donig anything wrong? Is there another method to execute macros?