Export Report to Excel

[AdisRod]

Hi,

I have 20 pages access report. I want export each page to
different excel sheet in the same workbook?

Thank you in advance,


Adis

 

[Adam P]

This may not be what you're looking for, but this works
for queries.

The following will append
multiple queries to one sheet in excel:

DoCmd.TransferSpreadsheet acExport,
acSpreadsheetTypeExcel9, "File name", "File path\File
name.xls"

Or, you can use this code to make multiple sheets:

DoCmd.OutputTo acOutputQuery, "File name",
acFormatXLS, "File path\File name.xls"