Export Report in Excel format (1 Viewer)

Moore71

DEVELOPER
Local time
Today, 06:39
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
 

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 23:39
Joined
Aug 30, 2003
Messages
36,118
Check out TransferSpreadsheet. Personally I had trouble getting a report to export properly. I typically export the underlying query.
 

taifoor

Registered User.
Local time
Today, 10:39
Joined
Jul 16, 2015
Messages
62
You may use either:

OutputTo command or
Docmd.runmenucommand.accmdexporttoexcel
 

Users who are viewing this thread

Top Bottom