Using VB copy contents of a macro to workbook

[jminu_2k]

Hi Everyone,
I'm using VB to create a excel workbook(book1).I have another exce
workbook(book2) which contains a macro. Is it possible t
programmatically copy the contents of the macro from book2 to book1?
If yes, how should it be done?

Thanks,
Meen

 

[Norman Jones]

Hi Meena,

See Chip Pearson's discussion on adding modules with code

http://www.cpearson.com/excel/vbe.htm

 

[jminu_2k]

Thanks a lot the the link,Norman.It was useful.

There is another requirement to prgrammatically add a user form to th
created excel workbook(book1).

Could you pls help in this regard