Programmatically delete Module1 from a workbook

G

Guest

Is there a way to programmatically delete a module from a workbook. I have
about 50 workbooks with this obsolete (and obnoxious) module in it. I just
need the specific code to do this. I'm calling the workbook oWB.

Thanks,
Barb Reinhardt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Programmatically opening workbooks in macros brings up Enable Macr 15
Programmatically determining CODE NAME for sheet based upon Sheet 14
Stuck on SaveAs FileFormat in Excel 2007 VBA 6
Syntax for getting value of named workbook range 1
Referring to two different open worksheets in code 8
Programming the VBA Editor Question 5
Enable macro message on VBA Workbook Open then macro ends 2
Copy used range from one worksheet to another (and lose the pivot) 3

Top