Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export reports as worksheets into one excel file

Status
Not open for further replies.
jozino01

jozino01

Technical User
Apr 25, 2003
257
CA
Hi,
I use the following command:

DoCmd.OutputTo acOutputQuery, "REVENUE DETAIL", acFormatXLS, True

to export report to excel (it creates one excel file).

How should I modify the code if I want to export two or three reports into one excel file, each report as a separate worksheet? I want to open the new excel file after export is done.

Any hint, please?
 
Status
Not open for further replies.

Similar threads

Teri Bridges
  • Locked
  • Question
Reports Combobox-List box
Replies
1
Views
445
dhookom
dhookom
GPnew
  • Locked
  • Question
Access 2016 report export to excel column order changes
Replies
2
Views
227
GPnew
GPnew
breezett93
  • Locked
  • Question
What should be multiple reports is becoming one report with multiple pages 1
Replies
13
Views
404
dhookom
dhookom
lameid
  • Locked
  • Question
Docmd.OutputTo Not Exporting Subreport
Replies
2
Views
324
lameid
lameid
puforee
  • Locked
  • Question
Sending report to email as a xcel file and incorrect information shows.
Replies
2
Views
212
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top