Check status for url and validate redirects

Hi

I need some help to modify a a VBA code.

The sheet should have 4 columns: URL, HTTP Status code, Redirect, Redirect HTTP Status code.

I have found this code and it can fill out the first two columns.

Please Login or Register  to view this content.

Basically I want to check the HTTP status code of many URLs. When the status code shows a redirect I should get the redirect URL and the status code of the redirect URL. Is it possible?

Best regards
Morten

Hi Jeremyfox36,

Thank you very much. It works perfectly :-)

Best regards
Morten

Originally Posted by jeremyfox36

Hi Morten,
Just for your information - when I was working it out I found that there can be several levels or redirect (sometimes up to six) so you might get a redirect from the second URL as well as the first.

Thanks, I know that. But it's okay to only see the status code of the last URL in the link chain.

Originally Posted by jeremyfox36

Check out this tool: http://redirectdetective.com/ with the URL www.microsoft.co.uk

Great tool! I have been searching for such a tool to trace a URL.

I'm not getting a good result on these url's. There is a difference between the result in Excel and the url tracer tool you mentioned.

Result from Excel:

http://shop.mediqdanmark.dk/katalog/...2/2353/4620001 | 301 - Moved Permanently | http redirect request failed | http redirect request failed
http://shop.mediqdanmark.dk/katalog/...5/3516/4622004 | 301 - Moved Permanently | http redirect request failed | http redirect request failed
http://shop.mediqdanmark.dk/katalog/...5/3519/4611040 | 301 - Moved Permanently | http redirect request failed | http redirect request failed

Result from online url tracer:

When I check the url with this tool "http://redirectdetective.com/" I'm getting this result: 301 permanent redirect => 301 permanent redirect => Final destination. It seems like the url is working, but in Excel I'm not getting the correct result.

Do you know, what can be wrong? Is it the code? Is it because the final destination url contains special Danish characters like 'זרו'?

Best regards
Morten

I appreciate your help - thanks a lot :-)
I will check out your modified code and see if it solves the problem.

Best regards
Morten

I'm just curious - what are you using it for? PM me if you like.

It's okay. In our catalog our suppliers have the opportunity to give us an url for which leads to their own product website. We want to check the url or redirect, so our customers not click on an url and get a 404 or another error code.