Modules

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to write a piece of VBA that takes a copy of a workbook, deletes
various sheets, deletes the module that is attached to the sheet and then
e-mails it to a list of recipients.

I have managed to acheive everything EXCEPT the deletion of the module. Can
anyone give me the code to delete "Module1" from my workbook using VBA.

Thanks,

Rich
 
Sub DeleteModule()
Dim VBComp As VBComponent
Set VBComp = ThisWorkbook.VBProject.VBComponents("NewModule")
ThisWorkbook.VBProject.VBComponents.Remove VBComp
End Sub



You need to have the Microsoft Visual Basic For Application
Extensibility library activated in your references
 
You must log in or register to reply here.

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

Excel 2003 - VBA to get a list of Module names in the project 4
renaming VBA "modules" 4
How to fix mystery sheet 2
How to Copy a VB Module 7
Please explain modules/sheets/workbooks 5
Use spreadsheet cells for global variable space? 2
Delete a sheet and delete a module in Another Worksheet then save 4
Export Sheet Values to new workbook 20

Back
Top