3

In my workflow I frequently need to open the explorer file location of a spreadsheet I'm working in, and it's tedious to click File -> Info -> Open File Location every time.

Is there a way to add that command to the Quick Access Toolbar? It doesn't show up in the command list, as shown.

The following question/answer isn't relevant here, because it's about a different command. How do you add the "local open" button to the quick access toolbar in Excel 2010?

Improve this question
0

3 Answers 3

Reset to default
1

Appears this snippet of VBA code will do the trick. You'll just need to figure out how to save to use for all workbooks, and, then add it to your QAT.

    Sub OpenFolder()
    Application.Dialogs(xlDialogOpen).Show ActiveWorkbook.Path
    End Sub
Improve this answer
1
  • Using this snippet but following Andrew Tran's steps below, I was able to get a button working properly! Thanks guys :)
    – Lethal Left Eye
    Mar 14, 2023 at 16:48
1
  1. Open development tab -> open Visual Basic
  2. Menu: insert -> module
  3. Paste the following code under vbaproject(personal.xlsb)
Public Sub Opener()
    Application.Dialogs(xlDialogOpen).Show ActiveWorkbook.Path+"\\"
End Sub
  1. Save and close the VBA
  2. Modify quick access toolbar and add the macro Opener (remember to add icon as well)
Improve this answer
1

A workaround I found:

Alt + F, I, F

This opens the containing folder.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .