Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy XL macros from one PC to another
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 ToolsAdd-ins. Gord Dibben Excel MVP On Fri, 22 Apr 2005 13:40:01 -0700, "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Function | Excel Discussion (Misc queries) | |||
Copy and pasting files with macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
How do I copy excel macros from one pc to another? | Excel Discussion (Misc queries) | |||
Copy macros to new computer | Excel Worksheet Functions |