Print ms access report to Excel

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

Guest

I have an MS Access report that I need to export to excel. What is the
syntax for doing this using vba?

I thought "transferspreadsheet" would work but i dont see anything for
selecting the report, only tables and queries.

Thanks,
Mike
 
Try this

docmd.OutputTo acOutputReport,"ReportName",
acFormatXLS,"LocationAndNameOfFile"
 
Back
Top