delete modules of code

**khalid79m** · 11-22-2007, 09:31 AM

how can i delete a module in vba, using a vba script.

so when i run "filereducer" (this gets rid of everything that file will no longer use) i have 2 modules of code ...that i want to delete, one is called ssrOne and ssrTwo

Can anyone help ?

**dominicb** · 11-22-2007, 10:52 AM

Good afternoon khalid79m

It certainly is possible to use a macro to delete macros - however a macro cannot be used to delete itself leaving nothing. As a consequence your workbook will always have to have the macro deleting code in it.

If you want to pursue this, then make this link your first stop : it looks quite in depth at using macros to control the VBE :
http://www.cpearson.com/excel/vbe.aspx

HTH

DominicB