Hi,

I need code that will open .pdf files, i know that ThisWorkbook.FollowHyperlink "C:\folder\where\pdf\files\are\bill.pdf" works but what I need is
code that will use name of file I need to open from textbox in userform.

Maybe something like this:
ThisWorkbook.FollowHyperlink "C:\folder\where\pdf\files\are\" ---> here I need something to implement name of file from textbox

I tryed:

Private Sub Button1_Click ()

bill = TextBox1.Value

ThisWorkbook.FollowHyperlink "C:\folder\where\pdf\files\are\" & bill

End Sub

but this doesn't seem to work...

Thanks for any help,
JanF