View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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