Error with On Error?

Good Friday Morning, Gurus.

I wrote a simple code to automatically save a workbook as a temp file when opened, so as not to corrupt the original data. I added an error handler so that if someone was working with the temp file, and it was already open when someone tried to save another temp file, it would save as temp2. As further precaution, I added temp3 and temp4, in case someone still had both 1 and 2 open. (Following me?)

Here's the problem. The original temp file saves fine. If I leave it open, and try to save another, temp2 saves fine. If, however, I have both temp and temp2 open, I get the error "can't save as the same filename...."

Why does my code below not skip to file3 when it encounters this error?

Here's the code:

Please Login or Register  to view this content.

Thanks in advance.

Hutch

Good morning, Roy.

Correct. It is a file name conflict.

I am mearely trying to save the file as a different file on opening so that the original data stays in tact even if the user makes changes to the "temp" file. The error handlers were only there to deal with the instances of one user opening the file, saving as temp, and still using it when another user tries to open the file and save as the same file name.

Any suggestions?

Thanks. Jerry.

That's a much better idea. Thanks for that.

Have a great weekend!