how do I create a personal folder

[Billy]

i have a few vba procedures on my pc. i was going to copy them to my
bosses personal folder in the VBA Editor, but i cannot see where he
has a personal folder. how do i create one on his pc? Excel
2002...Windows XP

Tonso

 

[JW]

I'm guessing that you mean PERSONAL.xls. The easiest way to create it
is to click Tools|Macro|Record New Macro. From the popup dialig box,
select Personal Macro Workbook from the Store Macro In combo box.
Click OK. You can now go ahead and stop the recording process of the
macro. This should create the PERSONAL.xls file and place it in the
XLSTART folder.

 

[Billy]

I'm guessing that you mean PERSONAL.xls. The easiest way to create it
is to click Tools|Macro|Record New Macro. From the popup dialig box,
select Personal Macro Workbook from the Store Macro In combo box.
Click OK. You can now go ahead and stop the recording process of the
macro. This should create the PERSONAL.xls file and place it in the
XLSTART folder.





- Show quoted text -

I have tried that. Ther is no Personal. There is no Personal.xls
folder there either.
Billy

 

[JW]

There IS no personal.xls folder. Confused on what you mean by
folder. personal.xls is a file, not a folder. It should be stored in
the XLSTART folder, depending on office version.

You can create a new workbook in Excel, go to SaveAs and save it as
PERSONAL.xls and save it in C:\Program Files\Microsoft Office
\OFFICE11\XLSTART (for Excel 2003 anyways). Once saved, go to Window|
Hide. Then exit Excel. When asked if you want to save changes to
PERSONAL.xls, select Yes. Restart Excel and make sure that the
PERSONAL.xls file opened.

 

[Ron de Bruin]

See
http://www.rondebruin.nl/personal.htm