T
tsraj
I am trying to create a Hyperlink to open a file from an Excel spreadsheet.
Only a part of the file name (a few characters) is in the spreadsheet. I
tried using * as wild card character to represent other parts of the name.
ex: =HYPERLINK("e:\Disc 1\MP 200\","*"&K1018&"*"&".PDF"). Cell K1018
contains part of the file name. When I click on the Hyperlink it takes me to
the subfolder but it is not opening the image file. Do I have to use any
other character for the wild card?
Any help in this regard is very much appreciated.
Only a part of the file name (a few characters) is in the spreadsheet. I
tried using * as wild card character to represent other parts of the name.
ex: =HYPERLINK("e:\Disc 1\MP 200\","*"&K1018&"*"&".PDF"). Cell K1018
contains part of the file name. When I click on the Hyperlink it takes me to
the subfolder but it is not opening the image file. Do I have to use any
other character for the wild card?
Any help in this regard is very much appreciated.