Exporting the report to exel

[vasu1211]

i am trying to export a report into an exel file. I have used conditional formatting to highlight few records in the report. Now when i export it to exel t that formatting no longer exists. Is there a way to export a Access report to exel while still maintaing the formatting. Any code which would automate the export of the report ? Please help

 

[pbaldy]

The best ways I've found to maintain formatting in a report is to export to Snapshot or PDF formats. If you want to maintain formatting in Excel, you'll need to use Automation to do it, which is more involved that a straight export.

 

[vasu1211]

automate

can you please tell me how to automate the export with highligthing intact? Any code?

thanks

 

[pbaldy]

I'm at home, but searching here for "excel automation" should get you started.