Opening files in other programs
 

I'm very new to macros so I'll apologize for asking what is probably a
simple question. I want my macro to open a different program. I'm
fairly sure this is possible, but can anyone tell me how to do it?

Opening files in other programs
 

Have a look in vba help for SHELL

--
Don Guillett
SalesAid Software

"Ldf77" wrote in message
oups.com...
I'm very new to macros so I'll apologize for asking what is probably a
simple question. I want my macro to open a different program. I'm
fairly sure this is possible, but can anyone tell me how to do it?

Opening files in other programs
 

Ld

Use the "Shell" method.

Example..........

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 9 Apr 2005 05:01:31 -0700, "Ldf77" wrote:

I'm very new to macros so I'll apologize for asking what is probably a
simple question. I want my macro to open a different program. I'm
fairly sure this is possible, but can anyone tell me how to do it?