personal workbook
- Thread starter Dheeraj
- Start date
NARAYANK991
Excel Ninja
Hi Dheeraj ,
This link contains the VBA code :
http://www.pcreview.co.uk/forums/personal-xls-t3042393.html
Narayan
This link contains the VBA code :
http://www.pcreview.co.uk/forums/personal-xls-t3042393.html
Narayan
Hi Narayank991,
Thank you so much for the link, however there is a one line code that we can write in immediate code to get this path. I am actually looking for that.
Also, I want to add this workbook in Explorer Window so save my codes and make it available all the time.
Thanks,
Dheeraj
Thank you so much for the link, however there is a one line code that we can write in immediate code to get this path. I am actually looking for that.
Also, I want to add this workbook in Explorer Window so save my codes and make it available all the time.
Thanks,
Dheeraj
NARAYANK991
Excel Ninja
Hi Dheeraj ,
The following statement will do :
Msgbox Workbooks("personal.xlsb").Path
If you get an error message , try out the extensions .xlsx , .xlsm and , as a last resort , .xls
If you do not get the path using any of the above extensions , I don't think you have a personal.xls* file.
Narayan
The following statement will do :
Msgbox Workbooks("personal.xlsb").Path
If you get an error message , try out the extensions .xlsx , .xlsm and , as a last resort , .xls
If you do not get the path using any of the above extensions , I don't think you have a personal.xls* file.
Narayan
javedsebas
New Member
Dear Narayan,
It seems that I did not explained my question clearly. Let me explain it again.
Whenever we open any excel workbook, MS Excel opens another excel file in the backend. The name of that file is Personal.xls. This workbook is hidden and so we are unable to view it.
However, we can find the path of this file by typing one liner code in immediate window. Also, we can add this file in Project Explorer Window so that any module that we save in this workbook is available to us all the time.
One of my colleague in my previous organization had told me this and did this practically however, I have forgotten it now. I am unable to contact him.
I have posted a screen shot of Code Window for your reference at the following link. I took this screen shot using my Personal Laptop. I want same on my office Laptop as well.
https://skydrive.live.com/#cid=026B2D6B6519A9D7&id=26B2D6B6519A9D7!107
Thanks,
Dheeraj
It seems that I did not explained my question clearly. Let me explain it again.
Whenever we open any excel workbook, MS Excel opens another excel file in the backend. The name of that file is Personal.xls. This workbook is hidden and so we are unable to view it.
However, we can find the path of this file by typing one liner code in immediate window. Also, we can add this file in Project Explorer Window so that any module that we save in this workbook is available to us all the time.
One of my colleague in my previous organization had told me this and did this practically however, I have forgotten it now. I am unable to contact him.
I have posted a screen shot of Code Window for your reference at the following link. I took this screen shot using my Personal Laptop. I want same on my office Laptop as well.
https://skydrive.live.com/#cid=026B2D6B6519A9D7&id=26B2D6B6519A9D7!107
Thanks,
Dheeraj
SirJB7
Excel Rōnin
Hi, Dheeraj!
I previously read your post and NARAYANK991 suggestion, and I agree with him, the MsgBox statement will show you the path.
Looking at your posted image the issue is the personal workbook name: replace ".xlsb" by ".xls" in the MsgBox statement and it will work.
Regards!
I previously read your post and NARAYANK991 suggestion, and I agree with him, the MsgBox statement will show you the path.
Looking at your posted image the issue is the personal workbook name: replace ".xlsb" by ".xls" in the MsgBox statement and it will work.
Regards!