View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.