You can try this

ActiveWorkbook.FollowHyperlink "C:\Test.pdf"



--
Regards Ron de Bruin
http://www.rondebruin.nl


wrote in message ups.com...
I am trying to open a PDF from Excel VBA. I do not want to specify the
full path to "AcroRd32.exe" as it may be installed in different
locations on different PC's. I found the following code from Tom Ogilvy
but when I run it I get a file not found error. I know the file exists.
I can browse to it and double click it to open it. I want the
"Test.pdf" file to open with what ever program is associated with a
.PDF in windows.
I do not want to specify the program to use to open the file.

Sub OpenPDF()
Shell "Start.exe ""C:\temp\Test.pdf"""
End Sub
--
Regards,
Tom Ogilvy

I am running windows XP

Thanks
Scott Riddle