Print report in Excel

[Dr_Worm]

I have records that I need to export to an excel spreadsheet that has all the headings and formatting set up.

What is the best way to export and print the report from a command button.

 

[Corticus]

Hi Dr_Worm,

Try:

DoCmd.OutputTo acReport, "MyReport", acFormatXLS

You will have to modify your report a bit, but you'll notice your formats are more or less maintained.

Hope this helps,