Using macros to export tables to different tabs on excel spreadshe

S

seth1980

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
 
S

Steve Schapel

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?
 
Top