VBA code to export/import VBA Project Modules 97
Posted by Bruce Sommer on December 23, 1999 12:31 PM
In 95 the macros were worksheets and the below code worked: ( Where Update_Summary was the module name)
In 97, how do you copy a VBA module from ThisWorkbook to ActiveWorkbook ?
I have tried:
Set exportmodule = ThisWorkbook.VBProject.VBComponents("Update_Summary").CodeModule
to capture the code of the module in the variable exportmodule..... run into a wall after that. on-line help is not very...