Save a copy of a Workbook without its modules

[Jordi Pocurull]

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.

 

[Tom Ogilvy]

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

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