L
Lee
In EXCEL macros, I open external files (e.g.,
Workbooks.Open Filename:=FullPath ...) for data. When I
try to open a file that has already opened, I got a
message like "xxx is already open. Reopening will cause
any changes you made to be discarded. Do you still want
to open ..."
The question is for some other files, I don't get this
message even they are already open. I don't like the
message to appear. thanks.
Workbooks.Open Filename:=FullPath ...) for data. When I
try to open a file that has already opened, I got a
message like "xxx is already open. Reopening will cause
any changes you made to be discarded. Do you still want
to open ..."
The question is for some other files, I don't get this
message even they are already open. I don't like the
message to appear. thanks.