View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Keith Willshaw Keith Willshaw is offline
external usenet poster
 
Posts: 170
Default Find all running Excel Application objects


"news.bluewin.ch" wrote in message
...
Is there a way in vbscript to find all running Excel instances and check
what their open workbooks are?

Thomas




No , you can call system API's to list all running processes
to count the number of excel instances running but
AFAIK there's no way to specify which yu want to connect
to so as to be able to use automation to check the open
workbooks

Keith