check if file is already open
Hi,
I want a macro to check is a file, which is called upon, is already
open and if so skips the opening line of the code and proceeds with
the rest, otherwise proceed with opening the file.
Currently Excel asks me if I want to reopen the file and unsaved data
will be lost.
Cheers,
Harold
|