Activate a non-Excel Window

Hi everyone.
I'm working on an Excel sheet and one feature I would really need is for it to activate an external window (not Microsoft).
Is this even possible using VBA? Has anyone else had this need?

Thanks in advance.

See if this works :

Code:

---

Sub RunAnExe()
Dim strX As String, varProc As Variant

On Error Resume Next

strX = "C:\Users\YourComputerNameHere\SomeOther.exe" 'Your path here

varProc = Shell(strX, 1)

End Sub

---

Or maybe this :

Code:

---

Sub OpenConvertMe()
    Dim RetVal
    RetVal = Shell("C:\WINDOWS\Convert.EXE", 1)
End Sub

---

C:\WINDOWS\Convert.EXE" should be the full name and path to the program you want to open.

Quote:

---

Originally Posted by PinkyCyclops

Hi everyone.
I'm working on an Excel sheet and one feature I would really need is for it to activate an external window (not Microsoft).
Is this even possible using VBA? Has anyone else had this need?

Thanks in advance.

---

Is the other program already running and you just want to switch to its window, OR do you want to start the second program?

Quote:

---

Originally Posted by Paul_Hossler

Is the other program already running and you just want to switch to its window, OR do you want to start the second program?

---

Hi Paul
The other program is already running. Therein, lies the rub.

I just got the below to bring my Amazon Music app to the front:

Code:

---

Sub test()   
    AppActivate ("Amazon Music")
End Sub

---

Quote:

---

Originally Posted by georgiboy

I just got the below to bring my Amazon Music app to the front:

Code:

---

Sub test()   
    AppActivate ("Amazon Music")
End Sub

---

---

That is excellent - mission accomplished!!
Thanks everyone!