Is there a macro to follow a hyperlink and validate / record the HTTP response code?

I need to write a macro that walks down a column visiting every hyperlink and telling me if it is a good link or not (404)
This would basically be a link validator.