Exporting modules through VBA

[mparpala]

Dear All, I have a file which is distributed to around 20 users. I need to make some changes in one of the modules and instead of recalling all files and do the change manually I would like to create an update file and to export the new/updated module through VBA to all 20 user. Does anybody knows a way to do this? I am using Office 2007 by the way.Thanks.

 

[Gary McMaster]

There was a thread yesterday covering something very close to this. Maybe you can use some the code that was posted.

Gary

http://www.mrexcel.com/forum/excel-...ically-replace-modules-several-workbooks.html

 

[mparpala]

Hi Gary, that's exactly what I was looking for. Thanks a lot

 

[Gary McMaster]

Glad it helped. Welcome to the forum.

Gary