Check excel hyperlink is valid with vba code
Posted on 2008-10-31
I have an excel sheet with the below headings:
ID, Name, Link, Result
I have created a hyperlink in the column 'Link'. There are about 50 entrys at the moment. Some of these links are no longer valid. I wanted a function to run through the list and if the hyperlink is no longer available to put a 'n'o in the result column and 'yes' if it works.
I have been looking for code to validat hyperlinks but cannot find anything. Any help is appreciated