An problem of VBA for Excel?Please help me.

[Leo Zhang]

I want make a tool with VBA in Excel.It will can build a new Excel workbook
and, write MacroCode to the new one.How can I do this?
I have no ideal,so,please give some answer.Thanks a lot.

 

[Frank Kabel]

Hi
as a starting point see:
http://www.cpearson.com/excel/vbe.htm

 

[Leo Zhang]

Thank you , it's so kind of you !