Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, and 2016. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Jumping Around Folders.
If you work with multiple workbooks at the same time, you know that traversing folder (directory) paths in the Open dialog box can be tedious. For instance, let's assume you have a workbook you are working on. You open a second workbook, this one in a different directory. (You find it and open it after clicking your way to it in the Open dialog box.)
Now it comes time to open a third workbook. When you display the Open dialog box, Excel assumes you want to start from where you opened the previous workbook. What if you want to actually open it from the same directory in which the first workbook was located? Of course, you can again use the Open dialog box to traverse back to the original directory. An easier method may be to do the following:
Now when you use the Open dialog box, Excel starts in the folder you were last in, which was the one displayed in step 2—the one you want.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (12714) applies to Microsoft Excel 2007, 2010, 2013, and 2016. You can find a version of this tip for the older menu interface of Excel here: Jumping Around Folders.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
What would you do if every time you opened a workbook Excel told you it was locked? Here's how you can try to recover ...
Discover MoreDoes your macro need to add information to the end of a text file? This is called appending, and is done using the ...
Discover MoreWhen storing your Excel workbook, you need to specify a file name to be used for the workbook. Take a moment to consider ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2015-06-19 04:49:37
Dave Kerr
Does anyone have macro code to do this? Should I simply use the macro recorder to get my own?
Alternatively, is there a property or method associated with dialog boxes where I can set my own "default" folder when using the dialog box in a macro?
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2018 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, and 2016. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: 
Comments