Remove the module

[dayanand108]

hi,

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

on waiting
dayanand

[Norman Jones]

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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[Bob Phillips]

'----------------------------------------------------------------
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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>