Duplicating a Workbook

[Tim Marsden]

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

 

[Ron de Bruin]

Hi Tim

You can use SaveCopyAs

 

[Tim Marsden]

You're correct,

Thank You

Hi Tim

You can use SaveCopyAs