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

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

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