Code for Opening a PDF document

T

Traveling

I would appreciate help with the VBA code that would open a pdf document with a known path. I plan to use this to let users open documentation from a pull-down menu

Any help will be appreciated.
 
K

Karl E. Peterson

Traveling said:
I would appreciate help with the VBA code that would open a pdf document with
a known path. I plan to use this to let users open documentation from a
pull-down menu.

This one was originally written to open any web page, but really it executes the
default verb on any filetype:


Private 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

Public Function HyperJump(ByVal URL As String) As Long
HyperJump = ShellExecute(0&, vbNullString, URL, vbNullString, vbNullString,
vbNormalFocus)
End Function

Later... Karl
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top