Export entire contents of the report to Excel

[N_NAGESH]

Hi,

I have a report generated through a query.
Further to this, the report has text fields having calculations within the report.

I want to know how to export the entire contents of the report to MS Excel.

I have tried :;
DoCmd.OutputTo acOutputReport, "<report name>", acFormatXLS, , -1
However, I am not getting the all the contents in the report. Especially the contents in the 'report footer'.

Can anyone help me in this regard?

Thanks in advance

Nagesh

 

[llkhoutx]

Reports aren't exported to Excel, tables or select queries are. Format the Excel workbook in Access using VBA or manually or with Personal.xls macros in excel.