multiple queries to same excel workbook

  • Thread starter Thread starter Beginner
  • Start date Start date
B

Beginner

I have 3 different queries to be output to a single excel
workbook as three different sheets.

Right now, I have a macro with the different queries
outputting to 3 different excel workbook

Any help is highly appreciated.

Thanks in advance
Beginner
 
Use the TransferSpreadsheet action and use the same filename for each of the
three actions. ACCESS will add worksheets to the EXCEL file.
 
Thank you. It works...

-----Original Message-----
Use the TransferSpreadsheet action and use the same filename for each of the
three actions. ACCESS will add worksheets to the EXCEL file.

--
Ken Snell
<MS ACCESS MVP>




.
Click to expand...
 

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

Access macro: How to output 3 queries to 3 tabs in 1 Excel workboo 8
Output to macro action 1
Output to Excel 1
Excel Protection 2
Exporting Multiple Queries to the same Excel File 4
file name as a variable in "Output to" of macro 1
Exporting Access Information into Multiple Excel Tabs Using a Macr 2
Counting multiple memberships 1

Back
Top