Is there a way to copy macros from one pc to another?

[Linda]

Hi,
I have a user who would like to copy macros from another
users pc to his. Is this possible? If so how do I go
about it. If it is a sharing violation is there any way
around it ?



Thanks,
Linda

 

[Michael J. Malinsky]

You could copy the spreadsheet containing the macro onto the other PC. You
could also export the module from one PC and import it to the other as
follows:

In the Visual Basic Editor, right-click on the module to be exported and
select Export File. Select a save location. Then copy the file to the
other PC, open the VBE then go to File>Import File... and find the module to
copy onto the other PC.

HTH

 

[Mike Waldron]

Linda -

In the macro editor under the file drop down choose Export.
Follow the Wizzard. This will produce a file with a .BAS
extension. You can E-mail that to the new user. Then use
the editor's file -> Import to bring the new macro module
into the users editor.

The Help files have a good explanation of the process.

Regards,
Mike