Using VB copy contents of a macro to workbook
 

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

--
Message posted from http://www.ExcelForum.com

Using VB copy contents of a macro to workbook
 

Hi Meena,

See Chip Pearson's discussion on adding modules with code

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


---
Regards,
Norman



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

Thanks,
Meena


---
Message posted from http://www.ExcelForum.com/

Using VB copy contents of a macro to workbook
 

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

--
Message posted from http://www.ExcelForum.com