Export Report to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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.
 
Back
Top