Where Is The Personal Macro Workbook Stored and How to View It (Part 2 of 4)

Learn where the personal macro workbook file is stored on your computer, and how to view it. It is important to know the location of the personal macro workbook for backing up the file, and sharing or transferring it to a new computer.

Read the article and download the Excel file here:
http://www.excelcampus.com/vba/personal-macro-workbook-video-series/

The personal macro workbook file opens in the background every time you open Excel. You can see it in the Project Window of the Visual Basic (VB) Editor.

The file is stored in the XLSTART folder on the computer. Any Excel files in this folder will open when you open Excel.

You can locate the file path for the personal macro workbook by typing the following line of code in the Immediate Window in the VB Editor.

?ThisWorkbook.Path

Hit enter and it will return the path of the XLSTART folder where the personal macro workbook file is stored.

Other videos in this series:
How to Create a Personal Macro Workbook in Excel and Why You Need It (Part 1 of 4):
https://www.youtube.com/watch?v=rD2-mSbTuL0

How to Add Macro Buttons to the Excel Ribbon or Quick Access Toolbar (Part 3 of 4):
https://www.youtube.com/watch?v=dmdolFcS-fI

How to Add a Yes No Pop-up Message Box to a Macro Before it Runs (Part 4 of 4):
https://www.youtube.com/watch?v=rCh7ki9yVsM&t

Please leave a comment below with any questions, and don't forget to hit the LIKE button if you enjoyed this video. Thank you!!!

Видео Where Is The Personal Macro Workbook Stored and How to View It (Part 2 of 4) канала Excel Campus - Jon