Hyperlink

[Idan2]

Hey Everyone ,

I'm sorry if the content does not belong to here.
I made a hyperlink that shows a file in a folder.

I made this: =HYPERLINK("[\\Server\share\" & A16 & "\Times\" & B16 & "\" & C16 & ".mp4]", "For more information click here.")
Is linked to the folder: \\Server\share\folder1\Times\IVM\0000025.mp4
So far so good.

But I need that if a file does not exist in the folder, it's will show up in the excel as "Noting to see here" and not "For more information click here.", How can fix that?

Sorry for my poor English :|

[:) Sixthsense :)]

As far as I know, there is no inbuilt excel function to check the existence of a file.

You have to use UDF or Macro.