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?
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?
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks