personal macro workbook

**jazbath** · 09-09-2009, 01:00 PM

Hi,
I am wondering where does the Personal Macro Workbook resides.
I am using Microsoft Office Excel 2007 I checked in XLStart it is not there.
Thank you for your help.
Jaz

**D_Rennie** · 09-09-2009, 01:37 PM

Im prity sure that in excel 2007 you have to create you own xlstart file. Any excel files withen the xlstart file will automaticly open when you open excel.
aleats thats the conclusing i came to after playing around with it.

**jazbath** · 09-09-2009, 01:44 PM

D_Rennie
Thank you. I did some initial tests too, I recorded a macro and ask it to store in personal work book. it did store there, but I cannot find it in xlstart. I even searched it I could not see where it is located.
I am asking this because I want to get my personal macro work book for older version to the new version. Any thoughts..?
thank you
Jaz

**royUK** · 09-09-2009, 01:46 PM

Have you stored any macros in your 2007 Personal workbook? If not it won't have been created. This is where it should be

In Windows Vista, the Personal.xlsb is stored at C:\Users\user name\AppData\Local\Microsoft\Excel\XLSTART

In Windows XP its at C:\Documents and Settings\user name\Application Data\Microsoft\Excel\XLStart folder.

**jazbath** · 09-09-2009, 03:27 PM

Thank Roy, that helped.
Jaz

**royUK** · 09-10-2009, 03:17 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save