I have an Access application that consists of multiple tables/queries and reports.
I would like to add a command button to my Access form that allows the user to enter the name of a query or report to be analyzed with Excel. Upon entering the query or report name, Excel would be launched and the new Excel file opened for analysis.
Basically I want to automate the following steps into a command button:
1. Use the database window to select the table, query, form, or report to save & load into MS Excel
2. Select the Tools menu, point to Office Links, and click
"analyze it with MS Excel"
Does anybody have some VB code I could put in a command button to accomplish this?