How can I export multiple queries to the same excel file?

B

bdmsfan

How can I export multiple queries to the same excel file? Is it possible to
do it with a Macro and the OutputTo action? or do I need to do it using VB
modules.
Thanks
 
K

Ken Snell [MVP]

Use a macro to run the TransferSpreadsheet action. So long as each query has
a different name, you can use the same EXCEL filename and each query will be
written to its own worksheet within that file.

You also can do this via VBA code using DoCmd.TransferSpreadsheet.
 

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

Embed the same Excel multiple times 0
How can I get a Shareable URL via VBA code to a OneDrive image? 0
Autonumber field in Excel that behaves the same as Access 0
How to Select Multiple Emails using Surface Pen 0
Tracked changes by multiple people modified to one 0
(Word 2016/365) Removing white space between pages at a smaller zoom 0
Exported Excel File is Incomplete 7
Merging from an Excel file with graphics 1

Top