I export reports to Excel (built in feature of my accounting program). Until today I have not had an issue using macros store in my personal macro workbook. After an hour of tinkering, I’ve discovered that if I export the file to Excel (thus opening Excel), the macros are not available. Clicking on Macros only shows this.

But if I open Excel first, and open a blank document, then export the report, the macros show up. This has not happened in the past. Any thoughts?

​I export reports to Excel (built in feature of my accounting program). Until today I have not had an issue using macros store in my personal macro workbook. After an hour of tinkering, I’ve discovered that if I export the file to Excel (thus opening Excel), the macros are not available. Clicking on Macros only shows this. But if I open Excel first, and open a blank document, then export the report, the macros show up. This has not happened in the past. Any thoughts?  Read More

​