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

L

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
 
M

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
 
M

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
 
Top