Moving a macro to another computer

[saidanddone]

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

 

[akphidelt]

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.

 

[Gord Dibben]

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 Tools>Macro>Macros?

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