Where is your personal macro workbook located?

user_5910742 0
Viewed 64919

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?

vba excel
5 Answers

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

user_26469290

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
user_99622630
Related