create new macro in new workbook
 

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

create new macro in new workbook
 

Chip Pearson has a page on programming the VBE.

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

--
Jim Rech
Excel MVP

create new macro in new workbook
 

Thanks for the great link - exactly what i need.

Randy
-----Original Message-----
Chip Pearson has a page on programming the VBE.

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

--
Jim Rech
Excel MVP


.