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

" 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, 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

wrote in message
ups.com...
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?