Remove VB Module from workbook

[Nikos Yannacopoulos]

Is there a way to programatically remove a module from
either the acive or another open workbook?

My goal is to save a workbook with another name on a
network drive (through VB code), without including the VB
module in the original.

Any suggestions?

Thanks,
Nikos

 

[Chip Pearson]

Nikos,

Yes, it is possible. See www.cpearson.com/excel/vbe.htm for details and
example code.

 

[Nikos Yannacopoulos]

Chip,

Many thanks, that was relly helpful!

Regards,
Nikos