Tanya said:
I would like to set up a button with a macro attached
which will go to a directory with pdfs in it and be able
to click on a pdf and it then opens in adobe. Possible?
Yes, it is. Place the following line of code above the first Sub statement
in a module
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
Then in the same module, include the following routine
Public Sub OpenAcrobatFile(strFile As String)
ShellExecute 0, "open", strFile, vbNullString, vbNullString, 9
End Sub
Then simply call the routine, passing it the full pathname of the PDF file
you want to open.