I have a database program that will "print" (ie. export) query results to an Excel file. Problem is that the instance of Excel that this database opens does not have access to PERSONAL.xlsb, so I can't run any of my macros on the generated .xlsx file. I have to save the file, restart Excel, and re-open the file to use PERSONAL.xlsb.
How do I overcome this so Excel has access to my macros when the file is created?