i have this code below but I don't know how to get it to open outside of excel because my files are all in PDF format. How can I modify this?
Private Sub ListBox1_Click()
Dim strFileandPath As String
strFileandPath = (Label9 & ListBox1)
Workbook.open strFileandPath
End Sub
I got the files to open using this code but this doesn't open it on a pdf editor of my like, instead it opens it with adobe acrobat reader. any ideas?
Private Sub ListBox1_Click() ' Roof links
On Error GoTo er:
ActiveWorkbook.FollowHyperlink Address:=Label9 & ListBox1
Exit Sub
er: MsgBox " Folder Not Found" & vbNewLine & " Check B#"
End Sub
Bookmarks