Moving macro from one PC to another

[Guest]

Hi,

Someone else created a macro that I think resides locally on a couple of PCs
in my company. I can go in and edit the code of the macro. I want to keep
it on the existing computers but move it to a new one. Can someone tell me
how to move a macro from one PC to another? We don't have a common server.

Thanks,

 

[Guest]

When you say the module is on a 'couple' of PC's I suspect to is in the
personal.xls files of s 'couple' of users. If you don't have a network then
the only way is to get it on a disk manually put it on each PC:-

Open excel on a machine that has the macro and click ALT+F11 to open the VB
editor. Navigate to and right click on the module for the code you want to
share and and then click 'export file'

The code will be saved to a .BAS file which can then be imported to other
machines.

Mike