Wildcard in Hyperlink formula

[jalbes]

We have a makeshift parts list that we use at work. A couple of us find it hard to remember the some 3000 parts so we want to add pictures next to the part numbers so we can visualize the parts so we don't have to manually search for it. We decided to us the hyperlink function and use strings from the spreadsheet to populate a URL - just like this:

=HYPERLINK("D:\Company_Name\Data Files\Parts"&"\"&IF(A5>=8000,"8-series",IF(A5>=6000,"6-series",IF(A5>=5000,"5-series",IF(A756>=2000,"2-series"))))&"\"&A756&IF(G756="",""," ("&G5&")")&"\"&V5&"_"&"~"&".jpg","Click Me")

So the hyperlink should look like:
D:\Company_Name\Data Files\Parts\8000\8036 (dpc-0021)\8036-099-ny-gy-10-11_9.jpg

Instead, I see:
D:\Company_Name\Data Files\Parts\8000\8036 (dpc-0021)\8036-099-ny-gy-10-11_~.jpg

The bold portion is the part I'm having trouble with. Each picture will have a different Rev level that we don't keep track of in the spreadsheet, so I wanted to use a wildcard, and appears to be the source of my problem. Does anyone have a work around to this issue?

Thanks for reading.

[martindwilson]

since you are linking to something say
martin_1.text or possibly martin_2.txt or martin_3.txt
how would hyperlink know which one to choose if you used wild card? it couldnt open all 3.
i suspect you need to go down the vba route where it could look at folder and choose latest /only ,revison/version