Export Modules from Workbook & Import

[Jaye7]

I would like a vba script which will export all modules from workbook named excel template and then would import the modules into ALL open workbooks.
Your help would be appreciated.

 

[Simon Lloyd]

Check out this page on Chip Pearsons site http://www.cpearson.com/excel/vbe.aspx

 

[Jaye7]

Thanks Simon, however I had previously checked out C Pearsons site but I can't get the right code that will copy into ALL open workbooks, the codes I have will copy a module into a set workbook only.

 

[tusharm]

You may want to invest the time to learn how to create an add-in rather than proliferating code in multiple workbooks.

I would like a vba script which will export all modules from workbook named excel template and then would import the modules into ALL open workbooks.
Your help would be appreciated.

 

[Jaye7]

Hi Tusharm,

If you looked at both threads they are different questions, one relates to userforms and the other relates to modules, but part of the question relates to both, I didn't want an administrator slamming me for asking two different questions in one thread.