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.





JDonahou wrote:

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