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

Hi

We are using a VBA-Macro which opens about 180 files in order to updat
them. Sometimes it happens that one of those files, is already in use b
another user, then an error message appears which says “A file name
‘XY.xls’ already exists in this location. Do you want to replace it?
Then I press the “No” button. After that a Visual Basic error messag
pops-up “Run-time error’1004’: ‘XY.xls’ is read-only. To save a copy
click OK, then give the workbook a new name in the Save As dialo
box”.

The idea would be that the macro updates all 180 files unless one i
already in use. In this case the macro should just close the fil
without saving.

It would be great to get some help. Thanks a lot.

Michae

--
MichaelS
-----------------------------------------------------------------------
MichaelS_'s Profile: http://www.excelforum.com/member.php...fo&userid=2640
View this thread: http://www.excelforum.com/showthread.php?threadid=39680

Reply With QuoteReply With Quote