load a PDF file with VBA

[Guest]

I have a userform that loads files and the user double clicks on file and I
want to be able to load a pdf file, I have tried the shell method and
createObject non of these work can someone help please.
TIA
Charles

 

[Ron de Bruin]

Have you try this

Try

ActiveWorkbook.FollowHyperlink "C:\Test.pdf"

Or this example that Jim Rech posted

Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" _
(ByVal hwnd As Long, ByVal lpOperation As String, _
ByVal lpFile As String, ByVal lpParameters As String, _
ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long

Sub LaunchPDF()
ShellExecute 0, "Open", "c:\File.pdf", "", "", 1
End Sub