Home > Forum Home > Analyzing Corporate Financial Data > Automate Getting to MS Query Wizard Share

Automate Getting to MS Query Wizard

Excel Help for Automate Getting To Ms Query Wizard in Analyzing Corporate Financial Data


Forum TopicPost Reply Login

Automate Getting To Ms Query Wizard

Rate this:
(3/5 from 1 vote)
ConfusedHello,

I use MS Query Wizard in excel to manipulate data based out of a MS Access File. The process is currently manual, I go to the Excel >> Data Ribbion > Get External Data >> From Other Sources >> From Microsoft Query > Check the "Use the Query Wizard to create/edit queries" >> Select MS Access Database* (in the Databases tab) >> find the file located in a specific path >> hit OK and then the wizard pops up!

Is there anyway to AUTOMATE this whole process? I would like to click a button on the Ribbon which does all this in the background and when it done pops up with the Wizard so i can build my query!

Thanks for your help!
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Happy
Rate this:
(3/5 from 1 vote)
There are two main options to access the MS Query Wizard more efficiently.
  1. Create a quick access menu item by choosing Office Button > Excel Options > Customize > Data Tab > add the Get External Data From Other Sources item > OK.  You can also click Options when the Data Source dialogue appears to provide a path to the database in order to speed up access when opening this in the future.
  2. Create a VBA macro that executes all of the steps required.  You can record the steps in a blank workbook and then save the workbook as an Excel add-in. The add-in can then be made accessible at all times in Excel.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Automate Getting to MS Query Wizard in the