Using macros to export tables to different tabs on excel spreadshe

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Everyone,
I have a bunch of queries that I use to create many different tables in
Access that I then have to export to numerous spreadsheets, each having
various tabs. How can I setup a macro to accomplish this for me?

Thanks a lot,
Seth
 
Seth,

Use a TransferSpreadsheet action in your macro for each data export.
You can use the Range argument of the macro to specify the worksheet.

"Create many different tables"? Is this necessary? Probably you can
export directly from the queries?
 
Back
Top