Activate a non-Excel Window

[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.

[Logit]

See if this works :

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

[Logit]

Or maybe this :

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.

[Paul_Hossler]

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?

[PinkyCyclops]

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.

[georgiboy]

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

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

[PinkyCyclops]

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

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

That is excellent - mission accomplished!!
Thanks everyone!