Thread: File already in use by another user
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
MichaelS_[_2_] MichaelS_[_2_] is offline
external usenet poster
  
Posts: 1
Default File already in use by another user

Thanks for your answer. I am already using the DisplayAlerts =
False/True. Why do I need an error handler (sorry about this question)?
The only thing I want is to say “No” as soon as the message “A file
named ‘XY.xls’ already exists in this location. Do you want to replace
it?” appears.

Maybe I am doing it the wrong way.

Michael


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

Reply With QuoteReply With Quote