I have a software scheduling program that exports report data to Excel. I need access to a macro stored in my personal macro workbook that formats the report data. When I export the data to Excel this way, the personal macro workbook is not available in the instance of Excel that the workbook is opened in.
I have designated the path to personal.xls in the Tools>Options>General>At startup, open all files in: dialog, but to no avail. If I start Excel from the icon (normally), personal.xls loads fine, but it doesen't if launched when exporting from the other program. The only macros I have access to in the exported file are All Open Workbooks, This Workbook, and Book1. The Window>Unhide menu item is grayed out.
It doesn't matter if Excel is already running or not when I export to Excel.
Thanks for your help.