excelvba

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?

Solution

  • 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.