Print ms access report to Excel

F

franky

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
 
O

Ofer

Try this

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