How to open containing folder of the current workbook in Microsoft Excel?
If you need to access documents located in the same folder as your currently open Excel workbook, navigating through Windows Explorer to find the folder can be cumbersome. Wouldn't it be more convenient to simply click a button in Excel to open the containing folder directly? This guide will show you several handy tricks to do just that, enhancing your productivity and simplifying file management.
- Open the Containing folder of the current workbook with the formula
- Open containing folder of the current workbook with Kutools for Excel
- Open containing folder with VBA
Open the Containing folder of the current workbook with the formula
If we can get the saving path of the current workbook, it will be easy to open its containing folder. We can get the saving path of the current workbook with a formula easily.
Step 1: Select a blank cell, and enter the formula below, then you will get the current workbook's saving path.
=LEFT(CELL("filename"),FIND("[",CELL("filename"),1)-1)
Step 2: Copy the saving path from the cell;
Step 3: In Windows Explorer, paste the saving path in the address field at the top, and press the Enter key. Then it opens the containing folder of the current workbook.
Open containing folder of the current workbook with Kutools for Excel
Kutools for Excel's Open Containing Folder tool will ease your work and open the containing folder of the current workbook quickly.
After clicking the Kutools Plus > Workbook > Open Containing Folder, it opens the current workbook's containing folder. What's more, the current workbook is selected in the document folder.
The Kutools for Excel's Open Containing Folder can help you quickly open the containing folder, of the active workbook, and select the workbook in the folder. Click to know more about this Open Containing Folder feature.
Open the Containing folder with VBA
1. Click Alt+F11 to open a Microsoft Visual Basic for Applications window.
2. Click Insert > Module, and paste the following VBA code into the Module window.
3. Click Run to run the VBA code.
The VBA code on opening containing folder:
Application.Dialogs(xlDialogOpen).Show ActiveWorkbook.Path
Relative articles:
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
![Screen Shot of Excel (with Office Tab installed)](http://cdn.extendoffice.com/images/stories/kte-module/officetab-bottom-02.gif)