THE_HORSEPOWERSHOP
asked on
hyperlink test in excel
Using excel 2007, is there a formula or way to test a GENERATED hyperlink in a cell in EXCEL? One of my spreadsheets creates a list of hyperlinks and I was wondering if there was a way or forumla to test the hyperlink in each box to see if the file located at the http address pointed to from the cell really exists on the server or not.
ASKER
Yes, the macro does work, but I cannot igure out how to modfiy it for my needs. Instead of it popping up a MSG window when it find a bad hyperlink, I want it to CLEAR the cell with the bad hyperlink. How would I change the macro to accomplish this?
Ok maybe we need to make a loop for every cell then call the function that will perform Cell.ClearnContent()
I will try also and get back to you
I will try also and get back to you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am working on a different solution but will still try to integrate yours for future use. Points awarded.
http://www.excelforum.com/excel-worksheet-functions/621943-hyperlink-macro-to-internet.html