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