Hyperlink to search a specific Pdf file

**Rob Surina** · 12-02-2018, 04:57 PM

I have a an Excel Worksheet that provides a part number (Example: 5 S1 F1 F1 E3 W1)

And, I have a File Folder G:\PDF\ that has hundreds of .pdf drawings with similar part numbers.

I'm looking to Hyperlink the Excel worksheet part number 5 S1 F1 F1 E3 W1 and link the same part number (5 S1 F1 F1 E3 W1) from the file folder G:\PDF

is this possible?

**mehmetcik** · 12-02-2018, 05:58 PM

The attached userform does something like what you need.

The active part is


Private Sub Listbox1_Click()

On Error Resume Next
MyName = ListBox1.Value
ActiveWorkbook.FollowHyperlink ActiveWorkbook.Path & "\" & ListBox1.Value, NewWindow:=True

Windows(ListBox1.Value).WindowState = xlMaximized

Unload UserForm1

On Error GoTo 0
End Sub