Export three reports to one spreadsheet

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

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
 
Hi Beth,

If you use DoCmd.TransferSpreadsheet you can export multiple queries/tables
to new sheets in an existing workbook.
 
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"
 
Back
Top