Export Report to Excel using coding

[Benjamins via AccessMonster.com]

Hi,

I try to export a report using DoCmd.OutputTo but the format it had exported
is different form my report.

I also want to hid the fieldname of my field when exporting as there is field
name appearing in the excel

I have subform in my report. Will this affect the export appearance?