Adding macros to the Personal Macro Workbook

morst · May 15th, 2002, 06:31 PM

Hi

I am a newbie to Excel programming. My problem is that I have written a VBA routine for a client and I want the client to add this to his Personal Macro WorkBook.

My Question is simply how can I get the client to do this. I can send a worksheet with the macro nicely attached to a button on the toolbar. However, I want this macro to be universal to all workbooks and of course this is what the personal macro workbook is for.

My other problem is that the client is not that proficient in Excel/VBA and I need the installation procedure to be as painless o

as possible. Also I cannot do this personally.

Thanking you in advance

Moris

DZarlengo · May 15th, 2002, 06:55 PM

Most likely, you will have to call the user and walk them through the steps one at a time.

One way to solve the problem is to make sure the sub you created is on a separate module. Then export that module - it will go out as a .bas file.

Send it to the user as an attachment. You may have to rename the file if they have a firewall or other software that blocks .bas attachments.

Call the user and walk them through saving the .bas file to their hard drive, opening Excel, opening their Personal.xls VBA, then importing the .bas file. When they close Excel (saving Personal.xls), your module will be available when they restart Excel.

Note: If you want the module to show up with a name you define (instead of Module2, etc.) open it in notenook and change the name on the first line in quotes. That is what the module will be named after you import it - not the file name.

Good luck!

morst · May 15th, 2002, 08:55 PM

Thanks for the reply. My only problem is where is the Personal.xls file. Do I open it in Excel or should it be an existing file the users system. (I tried finding it on someone else's computer and no luck)

Thanks

Moris

stevebausch · May 15th, 2002, 09:35 PM

If you are lucky, there is a Personal.xls book already, and Excel is already opening it.

Or, maybe that's not being lucky, because then you would need to determine the content of the existing workbook.

I think the easiest is to send them a complete Personal.Xls workbook, and instruct them to install it in the XLStart directory.

It should be hidden by default; if they want to "see" it, they would need to Window-UnHide the workbook.

Keep in mind that Microsoft hasn't been too consistent where to put workbooks you want automatically opened, it could get a bit messy determining where exactly to install the workbook.

XLStart folder is a good place to start.

[ This Message was edited by: stevebausch on 2002-05-15 20:36 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 15th, 2002, 06:31 PM	#1
morst New Member Join Date: May 2002 Posts: 2	Hi I am a newbie to Excel programming. My problem is that I have written a VBA routine for a client and I want the client to add this to his Personal Macro WorkBook. My Question is simply how can I get the client to do this. I can send a worksheet with the macro nicely attached to a button on the toolbar. However, I want this macro to be universal to all workbooks and of course this is what the personal macro workbook is for. My other problem is that the client is not that proficient in Excel/VBA and I need the installation procedure to be as painless o as possible. Also I cannot do this personally. Thanking you in advance Moris

May 15th, 2002, 06:55 PM	#2
DZarlengo Board Regular Join Date: May 2002 Posts: 63	Most likely, you will have to call the user and walk them through the steps one at a time. One way to solve the problem is to make sure the sub you created is on a separate module. Then export that module - it will go out as a .bas file. Send it to the user as an attachment. You may have to rename the file if they have a firewall or other software that blocks .bas attachments. Call the user and walk them through saving the .bas file to their hard drive, opening Excel, opening their Personal.xls VBA, then importing the .bas file. When they close Excel (saving Personal.xls), your module will be available when they restart Excel. Note: If you want the module to show up with a name you define (instead of Module2, etc.) open it in notenook and change the name on the first line in quotes. That is what the module will be named after you import it - not the file name. Good luck!

May 15th, 2002, 08:55 PM	#3
morst New Member Join Date: May 2002 Posts: 2	Thanks for the reply. My only problem is where is the Personal.xls file. Do I open it in Excel or should it be an existing file the users system. (I tried finding it on someone else's computer and no luck) Thanks Moris

May 15th, 2002, 09:35 PM	#4
stevebausch Board Regular Join Date: May 2002 Posts: 809	If you are lucky, there is a Personal.xls book already, and Excel is already opening it. Or, maybe that's not being lucky, because then you would need to determine the content of the existing workbook. I think the easiest is to send them a complete Personal.Xls workbook, and instruct them to install it in the XLStart directory. It should be hidden by default; if they want to "see" it, they would need to Window-UnHide the workbook. Keep in mind that Microsoft hasn't been too consistent where to put workbooks you want automatically opened, it could get a bit messy determining where exactly to install the workbook. XLStart folder is a good place to start. [ This Message was edited by: stevebausch on 2002-05-15 20:36 ]