Is there a way I can test hyperlinks via VBA code to see if they actually open up? I get a data feed with websites in it for certain employees. Since there have been many problems with them, I've been manually checking them, but it is a big time waster. Then I update my database with the good links.
Ideally, I'd also like to test the links at run-time and record bad links in a log file to be fixed later. This is in case websites get changed after I test them. Then I won't have to rely on users of the database to tell me about broken links. Maybe I'm dreaming...
Help gratefully received.
NNone
---------------------------------------
The customer may not always be right, but the customer is ALWAYS the customer.
Ideally, I'd also like to test the links at run-time and record bad links in a log file to be fixed later. This is in case websites get changed after I test them. Then I won't have to rely on users of the database to tell me about broken links. Maybe I'm dreaming...
Help gratefully received.
NNone
---------------------------------------
The customer may not always be right, but the customer is ALWAYS the customer.