Exporting Reports to Excel

[P_Henry]

I am having problems in exporting report data to Excel. The detail section of the report gets exported, but the report footer section andd group footer section do not. The command that I am using to do this is

DoCmd.OutputTo acOutputReport, stDocName, acFormatXLS, , -1, ""

Is there some way out?

Thanks,
Priya