how do I create a personal folder
 

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

how do I create a personal folder
 

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 wrote:
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

how do I create a personal folder
 

On Oct 18, 8:58 am, JW wrote:
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 wrote:
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- Hide quoted text -

- Show quoted text -

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

how do I create a personal folder
 

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.
Billy wrote:
On Oct 18, 8:58 am, JW wrote:
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 wrote:
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- Hide quoted text -

- Show quoted text -

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

how do I create a personal folder
 

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"JW" wrote in message ups.com...
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.
Billy wrote:
On Oct 18, 8:58 am, JW wrote:
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 wrote:
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- Hide quoted text -

- Show quoted text -

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