View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Robert Mulroney[_3_] Robert Mulroney[_3_] is offline
external usenet poster
 
Posts: 71
Default Prevent multiple instances of Excel from starting


Thanks guys. I've explored some options that use the Windows API to check
the list of running processes. I don't really want to give my users the
capability to run scripts that simply terminate processes. That could lead to
some, well.... "problems".

I've noticed that a lot of objects in excel have an "Application" property.
There must be someway that I can compare "Applications" for each open
document and terminate all but one using the "Application.Quit". That seems a
little safer to me.

Any thoughts?


- Rm