Excel 2003 macros

P

pspeed

I have made many macros in Excel and now that I am getting a co-worker would
like to know how to successfully copy/give them to her to use on her computer
(Excel 2003 running on XP operating system). Thx.
 
J

Jim Rech

Give her copies of the workbooks that the macros are in. If you're thinking
of your Personal.xls macros that file is usually in:

C:\Documents and Settings\<user name>\Application
Data\Microsoft\Excel\XLSTART

--
Jim
|I have made many macros in Excel and now that I am getting a co-worker
would
| like to know how to successfully copy/give them to her to use on her
computer
| (Excel 2003 running on XP operating system). Thx.
| --
| Pauline Speed
 
G

Gord Dibben

Copy all the macros to module(s) in a new workbook.

File>Save As>File Type>Add-in(*.xla)

Send her the file and tell her to put it into her Office\Library.

She can then activate it by going to Tools>Add-ins and checkmark it.


Gord Dibben Excel MVP
 
P

pspeed

Thank you, Gord. However, when you said 'tell her to put it into her
Office\Library' I'm not sure how to go about doing that. When it is saved as
an .xla file, will that file appear in the Tools\AddIns available dialogue
box?

I also have custom icons and custom menu bars and would like those to be
transferred also, if possible.
 
G

Gord Dibben

When you save the file as an add-in it will be saved in your default folder
which you have set up In Tools>Options>General.

You would copy it from there to a floppy or other removable media and carry it
over to her computer.

Copy from the floppy to her Office\Library folder.

It will appear in her list of Tools>Add-ins.

As far as the custom toolbars and menu items goes, there is no easy way to do
this without transferring your Excelx.xlb file also, which destroys any of her
customizations.

Read this google search result.

http://snipurl.com/ksoo

Dave Peterson discusses the subject in question.

And check out Jan Karel Pieterse's site for how to distribute macros.

http://www.jkp-ads.com/Articles/DistributeMacro02.htm


Gord
 
Top