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

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.