reopen a file

[Lee]

I got the following message when I reopen a file

"log.xls" is already open. Reopening will cause any
changes you made to be discarded. Do you want to reopen
log.xls"

But, I don't get such a message when I reopen another
file. How can I avoid this message?

I open files by the same statement:

MyPath = CurDir 'this is already opened in PSS
FullPath = MyPath & "\log.xls"
Workbooks.Open Filename:=FullPath

 

[NickHK]

Lee,
I would assume that you're not (successfully) closing the file in code
before you try to open it again.

NickHK

 

[Lee]

I didn't close file becasue I will get to ask whether I
need to "... save large amount of data [that I copy and
paste in the macro]..." and I don't know how to avoid this
message.

I don't understand why some other files I don't have the
problem and when other poeple running my codes on their
computer, they don't necessarily see the problem I have.

Thanks muhc.