Modules
 

I am trying to write a piece of VBA code that takes a copy of a workbook,
then deletes the module from the copy before e-mailing itself to someone.

I can do everything except delete the module.

Can anyone tell me how to delete "Module1" from workbook using VBA.

Modules
 

Have a look @ Chips Site

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

--
Ivan F Moal

-----------------------------------------------------------------------
Ivan F Moala's Profile: http://www.excelforum.com/member.php...nfo&userid=195
View this thread: http://www.excelforum.com/showthread.php?threadid=27515