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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook 2021 export question 0
Export Report with Graph to Excel error 2495 1
export using transferspreadsheet 1
How to make report 0
Export Access pivot table to Excel 0
Solved Disk Full error message when exporting PDF 0
Adding Cost Field to Appointment 0
Weekly Report 2

Top