Removing a module with code

[KimberlyC]

Hi

Is it possible to remove a module (with code) that is located in another
workbook.
Here's what I need to do:
I would like to run code from an addin file that would remove module1 in the
activeworkbook .

Any help would be greatly appreciated.

Thanks!
Kimberly

 

[Chip Pearson]

Kimberly,

Try something like


With ActiveWorkbook.VBProject.VBComponents
.Remove .Item("Module1")
End With

See www.cpearson.com/excel/vbe.htm for more details.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[David McRitchie]

Hi Kimberly,
See Chip Pearson's "Deleting A Procedure From A Module" within
Programming To The VBE
http://www.cpearson.com/excel/vbe.htm

You should be able to change ThisWorkbook.
to something like Workbooks("BOOK1").
and change the obvious things for module