Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving a macro to another computer
We have a macro that we run. I would like to be able to copy that macro to
another PC without having to recreate the macro. Is this possible? If it is possible, where would I locate the macro that I want to copy? I am running Office 2003 Professional on the 1st machine. I would be copying the macro to be used to a Office 2000 SBE machine, Is this even possible and if it is where would I copy it to? Thank You in Advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving a macro to another computer
Theres probably a really smart way to do it, but for the non-intelligent what
I do is just open the module... press Ctrl + A to select all the data, copy it and then paste it in a word or text document and e-mail it to myself... then just pick it up on the next computer. Not sure if this would work for you. "saidanddone" wrote: We have a macro that we run. I would like to be able to copy that macro to another PC without having to recreate the macro. Is this possible? If it is possible, where would I locate the macro that I want to copy? I am running Office 2003 Professional on the 1st machine. I would be copying the macro to be used to a Office 2000 SBE machine, Is this even possible and if it is where would I copy it to? Thank You in Advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving a macro to another computer
Relatively easy to do once you have figured out where your macro is located.
It could be in a Personal.xls workbook It could be in an add-in workbook or any workbook. How do you run the macro? Do you have a button with the macro assigned to it or a shortcut key? Is it viewable in ToolsMacroMacros? Once you find it post back. It may as simple as creating a copy of the workbook in which the macro resides and moving that copy to the other computer. Note: there may be some changes you have to make to run a 2003 macro on 2000 Gord Dibben MS Excel MVP On Wed, 14 May 2008 08:26:18 -0700, saidanddone wrote: We have a macro that we run. I would like to be able to copy that macro to another PC without having to recreate the macro. Is this possible? If it is possible, where would I locate the macro that I want to copy? I am running Office 2003 Professional on the 1st machine. I would be copying the macro to be used to a Office 2000 SBE machine, Is this even possible and if it is where would I copy it to? Thank You in Advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro will work on one computer but not on another | Excel Worksheet Functions | |||
Moving Macros from one computer to another Excel 2000 | Excel Discussion (Misc queries) | |||
How can I call My Computer through an Excel macro? | Excel Discussion (Misc queries) | |||
Moving to A NEW cOMPUTER | New Users to Excel | |||
Change links on moving to CD or another computer | Links and Linking in Excel |