Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From Outlook to Excel Personal Folder | Excel Worksheet Functions | |||
Personal.xls macro folder stopped working | Excel Programming | |||
Save file in a new folder, but create folder only if folder doesn't already exist? | Excel Programming | |||
Which is the good PERSONAL folder in XP Pro | Excel Programming | |||
Locking a personal folder on a shared drive | Excel Discussion (Misc queries) |