create new macro in new workbook

[Randy]

Hi Everyone,
In VBA / Excel is it possible to have a macro in
workbook1 create a file named workbook2 and have the
macro in workbook1 add a macro to workbook2?

What functions can do this ?

tia,
Randy

 

[Jim Rech]

Chip Pearson has a page on programming the VBE.

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

 

[Randy]

Thanks for the great link - exactly what i need.

Randy