Test Hyperlinks to files on Network Drive

Hello,
I am in need of a macro that will check to see if a hyperlink is valid. I am using the hyperlink function in Excel, not the wizard.
I have a large worksheet, and I would like the macro to test each hyperlink for validity without opening each file.

I found a thread that set me on the right direction here.

Here is the code that I have been using.

Please Login or Register  to view this content.

This code works great, but only if I hyperlink the files using the wizard. I have been using the formula for hyperlink because I need to include a cellular reference for the name of the file.
Here is a sample of the formula that I have been using to produce the hyperlink.

Formula:

Please Login or Register  to view this content.

I have Excel 2016.
This seems like a fairly simple change, but I don't know what to do. Please help!
Thanks,
Joe

You may need to Replace() file:///. e.g.

Please Login or Register  to view this content.

AlphaFrog,
That worked exactly the same as before. No errors, but it was unable to distinguish if the file was actually there.
Are we thinking at this point that there is no way to accomplish this?
I appreciate your effort.
Thanks,
Joe

Whoops. I thought I included that in my reply.
I need to use relative paths. It is a critical feature of the worksheet that I am working on here.

More information: Each line is a transaction and the hyperlink is linking in the receipt for the transaction that is named as the transaction number.
Relative references are necessary in the file name so I can grab the transaction number from the excel sheet, and grab the file that is named that number.

Thanks,
Joe

Wow. I didn't even know what relative paths were.
I inherrited this formula from my predecessor. Not sure why he used the relative references, but I changed them and now it works!
Thank you so much! You have saved my office and I so much work!
You are very skilled with Excel.
Thanks,
Joe