Hi,
I have a huge spreadsheet that has thousands of hyperlinks linking to various files on my local drive.
The way I set up my hyperlink was to refer to other cells to get the folder and file name, essentially:
=hyperlink(A1&"\"&A2&"\"&A3&".pdf",A3")
Say A1 has folder1
A2 has folder2
A3 is the File Name.
Ultimately what I end up with are the local hyperlinks to the files:
folder1\folder2\file.pdf
I want to check which links actually open files properly (the file pdf), and which links do not (meaning the file is missing, something isn't named properly, etc).
If the link doesn't work, I get the following error:
"Cannot open the specified file"
I want to somehow highlight the links that give that error so I can go and fix them.
I tried several different scripts that I found on this forum but none of them worked for me. Any help would be much appreciated! Thanks!
Bookmarks