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.

Answer 4

Just to build on swridings answer and have it paste that path to a cell so you can copy and paste it into the explorer, see below:

Sub Find_Personal_Macro_Workbook()

    Dim path As String

    path = Application.StartupPath

    Sheets.Add After:=ActiveSheet
    ActiveSheet.Range("$A$1").Value = path

End Sub

Answer 5

the personal macros are stored in a .xlsb file, usually PERSONAL.XLSB just use the Search function on your os drive (ie C:) and you will find it!