Using macros to export tables to different tabs on excel spreadshe

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Access Information into Multiple Excel Tabs Using a Macr 2
filter and export to excel 2
Export table to txt file with a variable filename 0
Use MACRO to export queries to specific SHEETs in ONE Excel file? 6
RunMacro - error when repeated 3
Export three reports to one spreadsheet 2
Routine to run/export queries 1
Problem creating export spec - "too few parameters" 1

Top