how to stop multiples of the same application from running

[johnnyplang]

I have an application that opens in VB but when then action is triggered again another instance of the program opens instead of maximizing the first instance. I tried the below but that doesn't work.

hwnd = FindWindow(vbNullString, "program X")
If hwnd <> 0 Then
AppActivate "program X"
Else
Shell ("c:\Program X.exe")
End If

(where Program X is my application name)

 

[firefytr]

Why not just create a whole other instance of the application? I'm assuming you're looking at creating an office application instance. Check out the GetObject/CreateObject methods. You should be able to get what you want from them.

-----------
Regards,
Zack Barresse