Adding Modules

JonWayn · Oct 28, 2003

How do I add a module to a workbook using vba codes?

ewize1 · Oct 28, 2003

This should work

ActiveWorkbook.VBProject.VBComponents.Add(vbext_ct_StdModule)

Tom Ogilvy · Oct 28, 2003

For additional information, go to Chip Pearson's site

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