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

should give you a start.

--
Regards,
Tom Ogilvy

"ScottG" wrote in message
...
We automate Excel (v10) to generate a bunch a workbooks which populate and
format themselves with an imbedded macro. Is there any way to
programmatically delete the macro before distributing the documents?