Launch Acrobat from Excel?

[Philip Reece-Heal]

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

 

[quartz]

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]

Brilliant

Many thanks for your trouble.

Philip

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