Output two queries to one Excel file

  • Thread starter andreas.strzodka
  • Start date
A

andreas.strzodka

Hello,

I have to queries and would like them to be exported into an Excel
Spreadsheet with two tabs, one for one query, the other one for the
other.

Does anyone have any ideas on how to do this since I am a bloddy
beginner.

Thanks,

Andreas
 
R

Ron2006

Just do the two "transferspreadsheet export"

And have the same "file Name" as the output. The two queries will
exported as two tabs with the tab name being the name of the query that
produced them.

Ron
 
J

Joel

I'm trying to do the same thing:

I have used docmd.output to command...if I use two line with different
queries to the same file I only end up with one file...the second one in the
code. Is there a way to make a second tab in the same file using
docmd.output to?


Thanks,

Joel
 
R

Ron2006

I do not see where you have any option / ability to do that with
docmd.output

Use "transferspreadsheet export"


Ron
 
Top