Export Report to Excel using TransferSpreadsheet

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

Guest

I am trying to export a report to Excel by using TransferSpreadsheet. Is it
possible to use the report name to export or do I have to use the query to do
so?

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "rptEmailTBC",
varGetFileName, True

My problem is that I have a report with a subreport and I would like to
export the entire report as it is.
 
Nope, you can export a table or a query, but not a form or report, using
TransferSpreadsheet.
 
Back
Top