Hyperlink to search PDF files

[Rob Surina]

I have a an Excel Worksheet that provides a part number in a cell (Cell A10 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 in cell A10 and link the same part number (5 S1 F1 F1 E3 W1) from the file folder G:\PDF

is this possible?​

 

[Rob Surina]

Additional Information:
The Excel Worksheet generates user defined part numbers in Cell A10

(Example: 5 S1 F1 F1 E3 W1 or 6 S1 F2 F2 E4 W2 or 7 S3 F2 F2 E4 W1....etc)
There are hundreds of possibilities to create these similar part numbers.

Additionally, I have a File Folder

G:\PDF\ that has hundreds of .pdf drawings with these same part numbers.

I'm looking to Hyperlink the Worksheet part number to the drawing.

Thank You!



​

<strike></strike>
​

 

[offthelip]

this hopefully shows you how to do it , I have just done it for A10 and put the link in B10, presumably you need to do it in a loop

Sub hyp()

Dim Filenm As String


Pathnm = "G:\PDF\"
Filenm = Cells(10, 1) & ".PDF"
newf = Pathnm & Filenm
      With Worksheets("Sheet1")
      .Hyperlinks.Add Anchor:=.Range(Cells(10, 2), Cells(10, 2)), _
                        Address:=newf, _
                        TextToDisplay:=newf
      End With






End Sub

 

[Rob Surina]

Hello offthelip,

Is it possible to do something like this as well?

=HYPERLINK("G:\PDF"&A10&".pdf",A10&".pdf")

Unfortunately, this doesn't work...

Rob

 

[offthelip]

I assume you mean this code doesn't work:

=HYPERLINK("G:\PDF"&A10&".pdf",A10&".pdf")

which it certainly won't , it has so many errors in it it isn't worht starting to correct it.
The code I gave you should work for the single example you gave us. What are really trying to do? I did say I presume you need a loop?

 

[Rob Surina]

Hello offthelip,

I've put together a sample worksheet and separate PDF folder to better explain the intended goal.
Is it possible to send you these items as an attachment?


Rob
​

 

[offthelip]

I realised after my last comment that you were using a FORMULA not VBA code, so my comment about the errors is completely wrong. I thin all you need to do to correct your formaul is add in a backslash:

[COLOR=#333333][I]=HYPERLINK("G:\PDF[/I][/COLOR][COLOR=#ff0000][I]\[/I][/COLOR][COLOR=#333333][I]"&A10&".pdf",A10&".pdf")[/I][/COLOR]

 

[Rob Surina]

Dear offthelip,

Thank you for the help.

The Hyperlink change you suggested WORKED!

I can't believe one backslash created such a problem.

You gotta love Excel..

Rob