Export Report to Excel

[Guest]

Hi,

I have designed a report on Access 2003, and wish to export it to Excel. I
used a simple VBA code:

DoCmd.OutputTo acOutputReport, "Main", acFormatXLS, "C:\rptRounds.xls", 0

Unfortunately, the formats aren't being exported. For example, on the report
i am using borders, color, different font size, etc, but none of them are
exported.

Will appreciate any help.

Thanks!

 

[Rick B]

Those items do not export.

If you need to see an exact image of your report, either view it in Access,
or save it as a PDF or a Snapshot format.