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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export report to excel ERROR - please help 3
Report export issue 2
Exporting Access Rpts to Excel 2
How to format excel 4
Export Report as csv format? 3
Exporting Report to Excel 2
Report to Snapshot Export Error? 4
Exporting Access report to Excel 2

Back
Top