View Full Version : Automate Getting to MS Query Wizard

10-06-2011, 01:05 PM

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!

10-07-2011, 05:18 AM
Cross-posted here (http://www.excelguru.ca/forums/showthread.php?470-Automate-Getting-to-MS-Query-Wizard).