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?
 

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

how to export the value of checkbox on a report in to excel 2
Exporting Report to Excel 2
Report exporting different data from what is on the report 1
report format can copy and paste 3
Exporting Report to multiple Excel sheets 2
Export to Excel Cuts Off Data 1
Exporting reports to Excel 1
Programatically export report object to excel 1

Back
Top