Export three reports to one spreadsheet

[Guest]

Help. I am trying to export 3 reports and have them all end up at the same
spreadsheet (don't mind if they are on different tabs) but at best they will
only export to 3 spreadsheets. I can get it to export Queries and tables but
I really need it to export Reports - any ideas

 

[SusanV]

Hi Beth,

If you use DoCmd.TransferSpreadsheet you can export multiple queries/tables
to new sheets in an existing workbook.

 

[Guest]

If what you mean is to export 3 reports to 1 workbook using a seperate sheet
for each report then try this code

DoCmd.TransferSpreadsheet acExport, 8, "report name", full file name",
False, "sheet name"