Where Is The Personal Macro Workbook Stored and How to View It (Part 2 of 4)
170.9 هزار بار بازدید -
8 سال پیش
-
Sign up for our Excel
Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...
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/person...
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):
How to Create a Personal Macro Workbo...
How to Add Macro Buttons to the Excel Ribbon or Quick Access Toolbar (Part 3 of 4):
How to Add Macro Buttons to the Excel...
How to Add a Yes No Pop-up Message Box to a Macro Before it Runs (Part 4 of 4):
How to Add a Yes No Pop-up Message Bo...
Please leave a comment below with any questions, and don't forget to hit the LIKE button if you enjoyed this video. Thank you!!!
00:00 Introduction
00:21 Where is the Excel Start folder
00:40 Where is the Visual Basic Editor
01:13 Where is the workbook
01:45 Open Windows Explorer
02:00 Open Excel Start Folder
02:50 How to View the Workbook
03:40 How to Hide the Workbook
04:32 Free Macro Training
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/person...
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):
How to Create a Personal Macro Workbo...
How to Add Macro Buttons to the Excel Ribbon or Quick Access Toolbar (Part 3 of 4):
How to Add Macro Buttons to the Excel...
How to Add a Yes No Pop-up Message Box to a Macro Before it Runs (Part 4 of 4):
How to Add a Yes No Pop-up Message Bo...
Please leave a comment below with any questions, and don't forget to hit the LIKE button if you enjoyed this video. Thank you!!!
00:00 Introduction
00:21 Where is the Excel Start folder
00:40 Where is the Visual Basic Editor
01:13 Where is the workbook
01:45 Open Windows Explorer
02:00 Open Excel Start Folder
02:50 How to View the Workbook
03:40 How to Hide the Workbook
04:32 Free Macro Training
8 سال پیش
در تاریخ 1394/12/28 منتشر شده
است.
170,961
بـار بازدید شده