Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personal.xls Where is it in 2003?
Hi guys,
I've just done a search of this newsgroup and read quite a few posts about the Personal.xls. I haven't got one but would like one. I'm writing quite a lot of bits of code that I refer to regularly, however this code is fragmented in lots of seperate workbooks. I'd [sensibly] like it all in one place. I've done a ?application.StartupPath In the immediate window and got this.. C:\Documents and Settings\ron\Application Data\Microsoft\Excel\XLSTART However this folder is empty. I've created a new Personal.xls and located it in the above folder, it does start when I start excel. However it isn't hidden and I'm led to believe it should be, but allowing me access to the sample code and modules I have written. Any help on this would be appreciated Ron |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personal.xls Where is it in 2003?
Personal.xls is no different from any other workbook except that you can
elect to have macros recorded there. If you record a macro, you will be given the choice of storing it in the personal.xls. If you select that and don't have one, it will be created for you. Since you already have created one. You just need to make it the active workbook, then do Window=Hide then make sure it gets saved when you exit excel. -- Regards, Tom Ogilvy "Ron" wrote in message 0.204... Hi guys, I've just done a search of this newsgroup and read quite a few posts about the Personal.xls. I haven't got one but would like one. I'm writing quite a lot of bits of code that I refer to regularly, however this code is fragmented in lots of seperate workbooks. I'd [sensibly] like it all in one place. I've done a ?application.StartupPath In the immediate window and got this.. C:\Documents and Settings\ron\Application Data\Microsoft\Excel\XLSTART However this folder is empty. I've created a new Personal.xls and located it in the above folder, it does start when I start excel. However it isn't hidden and I'm led to believe it should be, but allowing me access to the sample code and modules I have written. Any help on this would be appreciated Ron |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Personal.xls Where is it in 2003?
"Tom Ogilvy" wrote in
: Personal.xls is no different from any other workbook except that you can elect to have macros recorded there. If you record a macro, you will be given the choice of storing it in the personal.xls. If you select that and don't have one, it will be created for you. Since you already have created one. You just need to make it the active workbook, then do Window=Hide then make sure it gets saved when you exit excel. Thanks Tom, All sorted now. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Personal.XLS from 2003 to 2007? | Excel Discussion (Misc queries) | |||
XL 2003 and Personal.xls | Excel Discussion (Misc queries) | |||
Personal.xls blown away in 2003 update. | Excel Discussion (Misc queries) |