Using VBA to select applications...

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?

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

"[email protected]" wrote:

> 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?
>
>

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

On 24 Oct 2005 14:54:43 -0700, [email protected] wrote:

>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?

See the AppActivate statement.


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

<[email protected]> wrote in message
news:[email protected]...
> 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?
>