Remove the module
 

hi,

How can I remove a module from another module in existing workbook.
Is it possible or not?

on waiting
dayanand


--
dayanand108
------------------------------------------------------------------------
dayanand108's Profile: http://www.excelforum.com/member.php...o&userid=25464
View this thread: http://www.excelforum.com/showthread...hreadid=470668

Remove the module
 

Hi Dayanand,

How can I remove a module from another module in existing workbook.
Is it possible or not?

If you are asking how to delete a module prorammatically, see Chip Pearson's
page on VBE programming at:

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


--
Regards,
Norman



"dayanand108"
wrote in message
...

hi,

How can I remove a module from another module in existing workbook.
Is it possible or not?

on waiting
dayanand


--
dayanand108
------------------------------------------------------------------------
dayanand108's Profile:
http://www.excelforum.com/member.php...o&userid=25464
View this thread: http://www.excelforum.com/showthread...hreadid=470668

Remove the module
 

'----------------------------------------------------------------
Function DeleteModule(moduleName As String)
'----------------------------------------------------------------
Dim vbMod As Object

Set vbMod = ActiveWorkbook.VBProject.VBComponents(moduleName)
ThisWorkbook.VBProject.VBComponents.Remove vbMod

End Function



--
HTH

Bob Phillips

"dayanand108"
wrote in message
...

hi,

How can I remove a module from another module in existing workbook.
Is it possible or not?

on waiting
dayanand


--
dayanand108
------------------------------------------------------------------------
dayanand108's Profile:
http://www.excelforum.com/member.php...o&userid=25464
View this thread: http://www.excelforum.com/showthread...hreadid=470668