Home > Forum Home > Analyzing Corporate Financial Data > Automate Getting to MS Query Wizard > Quick Access Menu Options Share

Quick Access Menu Options

Excel Help for Quick Access Menu Options in Analyzing Corporate Financial Data


Forum TopicLogin

Quick Access Menu Options

Rate this:
(3.5/5 from 2 votes)
HappyThere 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
 
View Full Post

Find relevant Excel templates and add-ins for Quick Access Menu Options in the