What it does
Opens Windows File Explorer and navigates to the folder containing the saved active workbook.

When to use it
When you want to see where a file is saved to copy the file or use other files in the same folder.

Why to use it
It’s an easier and quicker way to navigate to the folder containing an Excel file than manually opening File Explorer and clicking through several subfolders.

Default shortcut
None

Other Details

• Category: Sheets / Files and Folders
• Difficulty: 1/5
• Usage/frequency: 3/5
• Automation factor: 3/5 (estimated 20 seconds saved each time used)
• Type: Shortcut
• Date added: 11/11/2017
• Tags: Folder, files

Related Macros
None

Other Articles
None

None

Prerequisites
None

Instructions
From your active saved Excel file, run the Open File Folder macro.  It will open Windows File Explorer and navigate to the folder containing the saved active Excel file.  Note that if the active file is not yet saved, File Explorer will just open to your default location (generally My Documents).

None