Export Multiple Query results from Access 2003 to one Excel Sprdsh

F

Fgbdrum

I have 15 queries set up to run in a Macro and want to export the results of
all of those queries in to one Excel Spreadsheet/Workbook. Can this be done
without using VB? If so, how?

Thank you.
 
F

fredg

I have 15 queries set up to run in a Macro and want to export the results of
all of those queries in to one Excel Spreadsheet/Workbook. Can this be done
without using VB? If so, how?

Thank you.
Click to expand...

Without VB? Sure.
You can manually select the query then click File + Export each time,
but wouldn't a few lines of code using the TransferSpreadsheet method
be easier and less prone to error?
 
F

Fgbdrum

It would be 100 times easier for sure. Automation is definitely preferred.
However, I know nothing about writing code in VB. Would you happen to know
what code would be necessary to make this happen?

Thank you.
 
Top