In other words you need to error handle to react to an already open
file, what you prefer to do is up to you. If you don't handle the error
the file won't be saved.
And Tom nor I assumed that was what you want.
And take into account that there can be other errors while saving your
file. Like a down network, not enough space on the media and others.


--
Dnereb
------------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182
View this thread: http://www.excelforum.com/showthread...hreadid=396807