Where is your personal macro workbook located?

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?

5 Answers

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.

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.

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

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 

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!