If document exists, stop

[moontho]

Me again.

One last thing. Using VBA I am opening a document in one directory and then saving it to another. I'm wanting to know if its possible for VBA to see if the document is already in the destination directory, and if it is... stop and say so.

Many thanks

thom

 

[PHV]

Take a look at the Dir function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244