snb;

I understand what you're doing. I'm just questioning whether it will work the way you have done it. I'm under the impression that SaveAs and SaveCopyAs cannot save themselves on to themselves. I admit that I haven't tried it yet, but I assume that Excel cannot save a file onto an open file. The fact that the names already exists would trigger "Do you want to Overwrite" question, but then because the file is in use by somebody, that it wouldn't let you save.