Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to load .xla file automatically? | Excel Discussion (Misc queries) | |||
How do I load a file from URL | Excel Programming | |||
File will not load | Excel Discussion (Misc queries) | |||
Is it possible to load an .xls file | Excel Programming | |||
How to load a help file using VBA | Excel Programming |