Remove VB Module from workbook
 

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

Remove VB Module from workbook
 

Nikos,

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

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com

"Nikos Yannacopoulos" wrote in message
...
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

Thanks!
 

Chip,

Many thanks, that was relly helpful!

Regards,
Nikos
-----Original Message-----
Nikos,

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

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com

"Nikos Yannacopoulos" wrote in message
...
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


.