Hi Guys. I apologize if this has been posted before, but kinda need a quick solution for a client. They are upgrading from Office 2003 to 2010 and have found a road block with Excel. This is how it works in 2003:

They open Excel and minimize it. Then, they run a report from their inventory control program, click EXPORT TO EXCEL. The report opens in Excel, and they are able to run a macro that reformats the look of the spreadsheet. As long as they open a blank worksheet prior to doing the export, the macros in the Personal.xls in the XLStart folder are available. If they don't open Excel prior to the Export, the Macros don't show up. I've tested this on my own Excel 2003 by creating a dummy macro.

Fast forward to Excel 2010. Macros don't show up when their inventory program (or any other program) opens Excel. They only show up if Excel is opened directly. How can I make the macros in the Personal.xlsb appear when Excel is opened from a third party program like in 2003?

Any help is appreciated.