Where is your personal macro workbook located?

Question

I'm looking for the Excel file where my personal macro workbook is stored. Does anyone know where that file might be on a Windows 7 computer?

Answer 1

Actually, I found the answer. You can find the file PERSONAL.XLSB by using the code below.

Sub Find_Personal_Macro_Workbook()

    Dim path As String

    path = Application.StartupPath

    MsgBox path

End Sub

Hidden items will need to be selected in your file explorer to see where this is.

Hope this helps anyone who needs to find this file.

Answer 2

In this folder: C:\Users\YourUser\AppData\Roaming\Microsoft\Excel\XLSTART

(Hidden Items needs to be selected in your files explorer)

If you don't have a Roaming folder use the Local folder. Rest of the path should be the same.

Answer 3

Follow the following steps: 1. Open Excel 2. Unhide Personal Workbook from View->Unhide 3. Press F12 to locate the path of the workbook.