Exporting Report to Excel via Command Button

[need_help12]

Good morning. Relatively new to Access, would appreciate any advice.



I have several reports that I'm able to generate within my database, but as I run these report I need to be able to export the results of the reports to Excel so I can in turn provide these reports to my internal business customers.

What's the easiest way to accomplish this? Is it possible to put a command button on the Report itself that, when generated, allows me to export the results to Excel?

Greatly appreciate any help. Thanks!

[R_Badger]

There is a visual basic command available, try taking a look at:
http://msdn.microsoft.com/en-us/library/ff192065.aspx

[need_help12]

Would the VBA example in this link you sent pull the data AFTER the report was run? I'm not well versed in code, so I want to double check.

[Robeen]

One method I use extensively in my Access Database applications is to create a macro that uses the ExportWithFormatting macro 'Action'.
You can set this action up in your Macro so that it exports your report to Excel.
What I do once I'm satisfied that my report is producing the correct data, is to create a Macro called 'AutoExec' and either put thisaction in there - or call the Macro that has the actino from inside the AutoExec macro.
Finally, I add a scheduled task in the Windows Task Scheduler to open the database at a set time.
When the scheduler opens the database, the AutoExec macro runs, executes all the actions in there - including the 'QuitAccess' action that closes the database.
I hope this helps!