| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Duplicating a Workbook
Hi,
If wish to open a Workbook called "WB1". I then change the workbook (but not save it). At this point I wish to duplicate "WB1" and call it "WB2". However I want to keep "WB1" open to carry on modifying it. If I do a SaveAs the name of the workbook changes to "WB2" and I have lost all reference to "WB1" Any suggestions tim |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Duplicating a Workbook
Hi Tim
You can use SaveCopyAs -- Regards Ron de Bruin http://www.rondebruin.nl "Tim Marsden" wrote in message ... Hi, If wish to open a Workbook called "WB1". I then change the workbook (but not save it). At this point I wish to duplicate "WB1" and call it "WB2". However I want to keep "WB1" open to carry on modifying it. If I do a SaveAs the name of the workbook changes to "WB2" and I have lost all reference to "WB1" Any suggestions tim |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Duplicating a Workbook
You're correct,
Thank You "Ron de Bruin" wrote in message ... Hi Tim You can use SaveCopyAs -- Regards Ron de Bruin http://www.rondebruin.nl "Tim Marsden" wrote in message ... Hi, If wish to open a Workbook called "WB1". I then change the workbook (but not save it). At this point I wish to duplicate "WB1" and call it "WB2". However I want to keep "WB1" open to carry on modifying it. If I do a SaveAs the name of the workbook changes to "WB2" and I have lost all reference to "WB1" Any suggestions tim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicating Folders | Links and Linking in Excel | |||
| Duplicating Worksheet to 20 sheet workbook | Excel Discussion (Misc queries) | |||
| De-duplicating | Excel Discussion (Misc queries) | |||
| duplicating information | Excel Discussion (Misc queries) | |||
| duplicating macros | Excel Programming | |||
Hybrid Mode
