This article sets out steps to follow when you get a scheduled report with a macro to execute
How to know if my report has macro
Your report has a macro if the file type is .xlsm (Microsoft Macro-Enabled Worksheet)
How to get results
- Save the file on a local folder (or network drive)
- Open the file and click on Enable Editing:
- Then click on
- Click on the button in the file looking like this:
- The macro will then execute and display results.
- Save the file again to save the results.