load a PDF file with VBA
 

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

load a PDF file with VBA
 

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


--



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


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