ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Programmatically delete Module1 from a workbook (https://www.excelbanter.com/excel-programming/396571-programmatically-delete-module1-workbook.html)

Barb Reinhardt

Programmatically delete Module1 from a workbook
 
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

Pflugs

Programmatically delete Module1 from a workbook
 
Yes, absolutely. See http://www.cpearson.com/excel/vbe.htm.

HTH,
Pflugs

"Barb Reinhardt" wrote:

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



All times are GMT +1. The time now is 05:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com