Excel 2003 Macro File

  • Thread starter Thread starter Don Guillett
  • Start date Start date
D

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.
 
Once I establish Macros in Excel 2003 can I easily
transfer these to another computer running Excel 2003?
 
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
 
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
 
Back
Top