View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Magnivy Magnivy is offline
external usenet poster
 
Posts: 70
Default Eliminate Read-Write Message

Hello,

I have a macro that opens each file in a directory, copies some data into
another file, and then closes each file. Sometimes, after I ran the macro,
messages pop up asking whether I want to open one of more of the files in the
directory in Read-Write mode. I think this is because my macro opened some
files that were in use by others (and so it opened them in a Read-Only mode)
and were subsequently closed.

Is there a way to eliminate this message?

Thanks very much for your help!
Magnivy