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

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

Brilliant

Many thanks for your trouble.

Philip

"quartz" wrote in message
...
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