Hyperlink Status Check Win7 Home Premium 64Bit + Excel2010

Hi,

as you can see in the title i want to check if hyperlinks are forbidden, not found/gone or unavailable atm
i already know winhttp isnt working, i tried xmlhttp but the versions i tried didn't worked also

in each worksheet is a button to the same macro (includes activesheet)
in the columns from g to m i got hyperlinks (the cell shows normal text)
for each of the most three internet errors the text i mentioned above shoul be recolored and the cell should get a comment
for example it should do something like that
error 503 should be colored in brown and the comment should be "Service unavailable at the moment"
error 403 should be colored in purple and the comment should be "Forbidden"
error 404 should be colored in red and the comment should be "Page not found"

if anyone has a solution i would be pleased to get the permission to use it

ps: i use win7 and excel2010 as you can see in title
links for multi/crosspost
http://computer.wer-weiss-was.de/vis...4bit-excel2010
http://www.mrexcel.com/forum/excel-q...excel2010.html
http://www.herber.de/forum/messages/1386607.html

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

I found that using GET caused a problem, the pages where taking too long to open. All of my links are PDFs so I sent a post which resulted in 405 (Method not allowed) or 404 )Not Found). Therefore I could assume 405 pages exist meaning I could check the links faster.

NB E4 is the top of the 196 links and I will never have more than 200 links so hard coding 200 is OK in this case.

Please Login or Register  to view this content.

Perfect even faster, Thanks Didn't see the HEAD option when looking this up for the first time. Awesome!