Determine if a workbook is already open
There is no provision for iterating through instances of excel. If you just
want to know if the file is open at all, you can determine that, but not by
iterating instances. If you want to work with the open file in an unknown
instance, there is no provision for it.
--
Regards,
Tom Ogilvy
" wrote in
message ...
Using VBA in open Excel workbook I want to determine if a specific
workbook
is already open. The complication is that multiple Excel processes may
already be open. What's the easiest way to do this?
I suppose what I'm really looking for is some way to iterate through all
the
open excel applications that are running and interrogate them to see if
one
matches the name that I am concened about...
Thanks in advance for any ideas.
|