Export Report in Excel format

Moore71

DEVELOPER
Local time
Today, 05:42
Joined
Jul 14, 2012
Messages
158
Hi,
Can someone help me with vba to export report in ms Excel format (Access 2010).
Thank you

Moore
 
Check out TransferSpreadsheet. Personally I had trouble getting a report to export properly. I typically export the underlying query.
 
You may use either:

OutputTo command or
Docmd.runmenucommand.accmdexporttoexcel
 

Users who are viewing this thread

Back
Top Bottom