Hi, Can someone help me with vba to export report in ms Excel format (Access 2010). Thank you Moore
M Moore71 DEVELOPER Local time Today, 11:30 Joined Jul 14, 2012 Messages 158 Nov 19, 2015 #1 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 Today, 04:30 Joined Aug 30, 2003 Messages 36,118 Nov 19, 2015 #2 Check out TransferSpreadsheet. Personally I had trouble getting a report to export properly. I typically export the underlying query.
Check out TransferSpreadsheet. Personally I had trouble getting a report to export properly. I typically export the underlying query.
T taifoor Registered User. Local time Today, 15:30 Joined Jul 16, 2015 Messages 62 Nov 26, 2015 #3 You may use either: OutputTo command or Docmd.runmenucommand.accmdexporttoexcel