Hyperlink to unknown file types (Pictures)

[MarkCBB]

Hi there,

I am using the following formula to Hyperlink to a picture:

=HYPERLINK($A$1&"\"&B1&".PNG",C1)

However not all; the pictures are the same file type, I tried the following formula but it didn't work:

=HYPERLINK($A$1&"\"&B1&".*",C1)

A1 =

C:\Users\user\Desktop\TEST

B1 = "Pic1"
C1 = Friendly name

is there a way to make this formula more robust to include all picture file types?

 

[Andrew Poulsom]

Sorry no. You can't use wildcards in hyperlinks.

 

[MarkCBB]

Is there a way to list the different file types? i.e. PNG and JPEG in the formula?

 

[Andrew Poulsom]

Sorry, no.

 

[MarkCBB]

That sucks, owell. Thanks anyway Mr Poulsom.

Kindest Regards,
Mark Blackburn

 

[energman58]

But there is no reason why your cell B1 could not contain the file name including the extension. If this is impossible for some reason as long as you know which files are which type you have you could make a lookup table of filename and extension somewhere else and include a lookup reference to that in your hyperlink.

 

[MarkCBB]

The challenge is that I will not know the file type, and there are 1500 pictures.

What I have done is created 3 different columns with Hyper-links, to different file types, so one of them will work.