You should first consider the logic behind one used trying to
save a document to a name that another user has already used.
This implies that you need to come up with some naming
conventions which will give unique names or come up with
a procedure for deciding which document is the real 2.xls.

Having said that - the easiest way to do what you want to do
is with error trapping.

Try to do what you want and if it fails then check why it failed
and if it failed because it was already opened or existed the you
take appropriate action. Of course, depending on your answers
to the above, there may very well be a better solution for you.

Chrissy.



Tim_S wrote
Ok this works great.

Now another big question is how can I tell if an Excel document is open and
locked before I do a save as

For instance;
I have 1.xls open and want to save it as 2.xls but joe another user has
2.xls open. I get an error in the macro when the macro tries to save it.