Creating Hyperlinks to files

[ChemistB]

Hi All,
I started this in another folder but have had very little luck. I think it requires a VBA solution.
In Column B (from B2 down), I have a list of SOP ID's

SOP-001
SPEC-425
SOP-00123
etc.

These documents are all located in a single folder (i.e. ("C:UserschemistbDocuments"), only the most recent revision will be there. However, the file name will also include the revision # and possibly a date.

SOP-001 Rev 7.3 11-12-2012
SPEC-425 Rev23.9 1-9-2011
etc.

So the part in Column B will always be the string before the blank. I want to create in column I, a hyperlink in each row to the document so I can open the files themselves with a click of the mouse. I cannot use Add-ins and haven't been able to figure out a way to do it with wildcards. Thanks for all input.

Original post:
http://www.excelforum.com/excel-form...-wildcard.html

[ChemistB]

Posted here:

http://www.thecodecage.com/forumz/mi...al-string.html

Solved:
In I2:

Please Login or Register  to view this content.

With this UDF:

Please Login or Register  to view this content.

Solution 2:
assuming the folder path (eg C:\Users\chemistb\Documents\ ) is in A1 and your partial file names start in B2, select I2 and then use name manager to create a new name called LatestFile using this:
=FILES(Sheet1!$A$1&Sheet1!B2&"*")
as the refersto property.
You can then use:
=HYPERLINK($A$1&LatestFile,LatestFile)
in I2 and fill down as required.