Using VBA to select applications...

[dennischou]

I'm trying to write a macro that activates or selects a non microsoft
application that is running but can't quite figure out how to make VBA
know which application to select.

Any ideas?

 

[Guest]

what application do you want to call??????????????

 

[Gord Dibben]

Dennis

Investigate the use of the "Shell" command.

Sub Internet_Explorer()
Dim taskID As Variant
On Error Resume Next
taskID = Shell("start iexplore.exe")
If Err <> 0 Then _
MsgBox "IEXPLORE.EXE is not installed on your machine."
End Sub


Gord Dibben Excel MVP

 

[Chip Pearson]

See the AppActivate statement.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com