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

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

On Oct 18, 8:58 am, JW <JWRIGH...@triad.rr.com> 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

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 <JWRIGH...@triad.rr.com> 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

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

--

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


"JW" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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 <JWRIGH...@triad.rr.com> 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
>