Copy XL macros from one PC to another

[JDonahou]

I'm needing to copy some XL macros off of one PC and use them on another PC.
How can this be done? What is the default location (directory) that they may
be stored on XP pro. What is the file ext.

TIA

JD.

 

[Dave Peterson]

Macros live in workbooks. So you just have to copy the workbooks from one pc to
the other.

But macros can be stored in regular workbooks (*.xls), addins (*.xla), template
files (*.xlt), and even old macro addins (*.xlm).

There is no single default location that contains all the macro workbooks. But
usual spots are the XLStart folder (actual name and location vary with the
version of excel and windows), the addins folder and any other location that the
user wants.

 

[Gord Dibben]

JD

Macros can live in the workbooks in which they were created or in
Personal Macro Workbook(Personal.xls).

You also could have placed the macros in a workbook and saved it as an
Add-in(*.xla)

If in Personal.xls, you must find that file and store it in your XLSTART
folder.

If in workbooks, just open those workbooks to access the macros.

If in an add-in, find it and load it through Tools>Add-ins.


Gord Dibben Excel MVP