View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nayan Nayan is offline
external usenet poster
 
Posts: 39
Default find count of multiple excel instances

Hello ,

If anyone knows how to get count of all the instances of excel that are open
at a time on the machine?

using getobject will reference to the instance of the excel application that
was opened first but it will not say how many instances are already open at
that point of time.

I need this value in a start up of an xla file which runs on loading of
excel (2003)
If more then one instance are open then I want to exit from furthur loading
of xla .

Thanks,

Nayan