Copy UserForms and Modules to another workbook 1

[mveera]

Hi,

Is it possible to copy the UserForms and Modules created in Workbook to another workbook.

Thanks
Veera

 

[RobBroekhuis]

Yes. An easy way to handle it would be to export it from one workbook (to a temporary file), then import into the other one. Something like:

ActiveWorkbook.VBProject.VBComponents("Module1&quot.Export "c:\temp\module1.bas"
OtherWorkbook.VBProject.VBComponents.import "c:\temp\module1.bas"



Rob

 

[mveera]

Thanks Rob.

I would like to know if it is possible to export all the forms and modules at one shot rather doing it one at time and then import separately.

Thanks
Veera

 

[RobBroekhuis]

It's fairly easy to do with code modules, but I don't know how to do it with userforms. Maybe somebody else will jump in with a solution... Rob