Open files from Listbox outside of Excel.

[kandoo1]

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?

Please Login or Register  to view this content.

[Norie]

For that code to work as it is I think you would need to change the application associated with PDF files to the one you prefer.