deleting modules

[rgandy]

hey all,
how can i delete a module from within the code?

i am trying vba.project.arrayname but there doenst seem to be any deletion functionality

thanks

 

[PHV]

Have you tried the VBIDE.VBComponents.Remove method ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[rgandy]

thank you. do i need to add the name of hte module to that string of code?

i am getting an "object required" error message upon execution when i place that line of code into the project

 

[PHV]

A starting point:
With Workbooks("yourWorkbook").VBProject
.VBComponents.Remove (.VBComponents("yourModule"))
End With

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[firefytr]

About everything you wanted to know about working with modules programmatically...

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

Here is a useful Knowledge Base entry at VBAX...

http://vbaexpress.com/kb/getarticle.php?kb_id=397

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci