| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to save a copy of personal workbook? | Excel Discussion (Misc queries) | |||
| Trying to use VBA to save a copy of a workbook | Excel Discussion (Misc queries) | |||
| Delete modules programmatically and save | Excel Programming | |||
| Copy Modules from One workbook to Active Workbook | Excel Programming | |||
| copy 3 sheets & save them into new workbook | Excel Programming | |||
Linear Mode
