Importing Modules

[JJKNowles]

Currently there are about ten people that use macros I have written. As the macros change I have to go to each person's computer and copy and paste the code into their personal work book. Is there a code that can import a module from the network and replace the old macro with the same name?

 

[Tazguy37]

You can use File, Import File from the menu to do that. Or were you looking for something more automated?

 

[Smitty]

See Chip Pearson's section on Programming to the VBE

HTH,

Smitty

 

[JJKNowles]

I am looking for more automated