View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
quartz[_2_] quartz[_2_] is offline
external usenet poster
 
Posts: 441
Default Launch Acrobat from Excel?

Hi, the following worked for me:

Dim sAcrobat As String
sAcrobat = "C:\Program Files\Adobe\Acrobat 5.0\Acrobat\Acrobat.exe"
Shell sAcrobat

I don't think you need: Start &

HTH

"Philip Reece-Heal" wrote:

Trying to launch Adobe Acrobat from a toolbar button in Excel and am having
difficulty with VBA code. Have tried:

Sub OpenAcrobat()
myfile = "C\Program Files\Adobe\Acrobat 5.0\Acrobat\Acrobat.exe"
Shell "Start" & myfile
End Sub

but keep getting 'File not found' error

Help gratefully appreciated

Philip