View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
L3Tech L3Tech is offline
external usenet poster
 
Posts: 5
Default check for running app

Thanks
I got it to work.
For my info, what is COM?
I am using excel 97. Is this something new?

Bob Phillips wrote:

If it is not COM (let's assume it is not) then test as I showed, and if not
there then Shell it. Here is an example using the Calculator program

On Error Resume Next
AppActivate "Calculator"
If Err.Number < 0 Then
Shell "C:\Windows\system32\calc.exe"
End If

You will know the path and app name for Shell, you can check the app by
starting it and see what is in Task Manager.