View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] hzgt9b@nopost.com is offline
external usenet poster
 
Posts: 15
Default Determine if a workbook is already open

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.