Macro that writes Macros
 

OK.

I usually do quite a lot of complicated excel/vba programming but this
is a problem I haven't found a solution to. I'm hoping some of the
experts here can help me out.

I want to write a macro that takes some user input and writes a new
macro based on that user input. So basically this new macro will have
to write either a new module or add to an existing module.

I hope someone knows how to do this.

Cheers

Sahil


--
schoujar
------------------------------------------------------------------------
schoujar's Profile: http://www.excelforum.com/member.php...o&userid=26574
View this thread: http://www.excelforum.com/showthread...hreadid=547298

Macro that writes Macros
 

hi

have a look at this
http://www.cpearson.com/excel/vbe.htm