Export Report to Excel using TransferSpreadsheet

E

Elleve

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.
 
K

Ken Snell \(MVP\)

Nope, you can export a table or a query, but not a form or report, using
TransferSpreadsheet.
 
Top