Good afternoon everybody,

I am working on a program that exports data from an Access query to an Excel
spreadsheet. I then need to run an Excel macro on that spreadsheet. Export
works fine and can see exported data in an Excel spreadsheet fine. But.....

If I open a standard excel spreadsheet alone and click on my macros menu, I
can see a list of macros, but if a spreadsheet is exported from Access to
Excel AND Excel gets opened on an automatic basis by a VBA command, then I
can see my exported data, but my list of macros is blank and seems
unavailable. Anybody know why? (I know Excel macros get stored in
personal.xls file so they can be used on any workbook. But do imported files
not have access to this?) They can't be stored locally to a workbook because
every time data is exported, the file is overwritten.