Exporting a report to excel using a command button and VBA

[sjs94704]

What would the VBA command line look like to export a report to Excel using a command button ?

[alansidman]

Look here for starters

http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

[ssanfu]

Also check out Ken Snell's Excel page (Importing and Exporting) at
http://www.accessmvp.com/kdsnell/EXCEL_MainPage.htm

[tanvi]

Please check this post: https://www.accessforums.net/forms/c...xcel-2120.html

Hope the post will help you to export a report to Excel!!