View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Can I run an external program?

You need to specify the program as I said

RetVal = Shell("C:\Program Files\Adobe\Acrobat 5.0\Reader\AcroRd32.exe Coax
Designer II.pdf", 1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
ups.com...
I tried the following:

Sub RunHelpFile()
' Specifying 1 as the second argument opens the application in
' normal size and gives it the focus.
Dim RetVal
RetVal = Shell("C:\Program Files\Coax Designer II\Coax Designer
II.pdf", 1) ' Run program.
End Sub

I get an "Invalid procedure call or argument (Error 5)" error message
however.