Thread: Save a copy of a Workbook without its modules
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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.




Reply With QuoteReply With Quote