Excel 2003 Macro File

[Don Guillett]

At least in 2002, macros are part of the file. So, if you move the file they
go too or you could copy/paste or export/import.

 

[Boyd Burnette]

Once I establish Macros in Excel 2003 can I easily
transfer these to another computer running Excel 2003?

 

[Otto Moehrbach]

Boyd
Macros reside in a file, either the file in which you built the macros
or in the Personal.xls file To move the macros to another computer you must
move (copy) the file. Post back if this is not clear. HTH Otto

 

[Gord Dibben]

Boyd

See specifically the text enclosed below by *******

1. UDF's and Macros can be stored in a workbook so they are available only
for that workbook.

2. They can be stored in a Personal Macro Workbook that is placed in the
XLSTART folder so they are available for all open workbooks.

3. They can be stored in a workbook which has been saved as an Add-in with
the extension *.XLA

I prefer putting my macros/functions into a personal Add-in(*.XLA) and having
that loaded whenever Excel is opened.

The reason I favor the Add-in route is that you rarely have a problem with
Excel finding the macros/functions when referred to by name only, without
preceding with Personal.xls!

******
Another advantage to the Add-in route is that you can send this Add-in file to
other users. This is preferable to overwriting the users' Personal.xls files.
******

One minor problem with an Add-in is that the macros don't show up in the
Tools>Macro>Macros list.

The UDF's you write will be available in the Function Wizard in
"User Defined" category.

Gord Dibben Excel MVP