Export of Report to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report which I run which creates a billing report for numerous
locations. By request of the accounting department, they want the reports in
Excel.
I know that there is the ability to export the report to Excel. Is there an
easy way to be able to export to multiple tabs for each page?
 
Here is some code you could put behind a command button.

DoCmd.TransferSpreadsheet acExport,
acSpreadsheetTypeExcel9, "QueryName", "FilePathToSaveTo",
False, "NameOfWorksheet"

Chris
 
Thank you Chris.
I gave that a try. However, since I am using a Query by Form, it wasn't
working.
 
Is this even possible, where you could have a multi-page report in Access,
export to Excel in multiple tabs? Or can it only export to a single tab?
 
Back
Top