Save a copy of a Workbook without its modules
 

I've an Excel workbook (WB1) with code that opens another Excel workbook
(WB2) that runs itself some more code and when the control returns to the
WB1 it saves a copy of WB2 with another name.

I want that that copy of WB2 be saved without including any VB code.

Save a copy of a Workbook without its modules
 

look at Chip Pearson's site for sample code that should get you started

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

--
Regards,
Tom Ogilvy


"Jordi Pocurull" wrote in message
...
I've an Excel workbook (WB1) with code that opens another Excel workbook
(WB2) that runs itself some more code and when the control returns to the
WB1 it saves a copy of WB2 with another name.

I want that that copy of WB2 be saved without including any VB code.