Thread
:
Remove VB Module from workbook
View Single Post
#
2
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
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
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson