Using VBA to find HTTP redirects

[AKK9]

Hi,

I'm trying to find a way to get VBA to do the following:

1. Follow a URL
2. Check if it's being 301 redirected
3. Get the URL it's redirecting to
4. Check that the redirect is not a 404

I made a way to use Internet Explorer to do this, but it means IE has to load and finish rendering the entire page each time. (This is faster than I can do it manually, and obviously means I don't need to be there, but it's kinda slow)

Any ideas?

Thanks,

[AKK9]

Any ideas? Maybe someone can point me in the right direction?

[Chippy]

You can do this with the WinHttpRequest object - see http://stackoverflow.com/questions/2...xmlhttp-object.

[AKK9]

Got it working. Thanks.

[Chippy]

Why not post your code for the benefit of others?

[AKK9]

Well, I haven't actually got anything working yet but had a quick read through the WinHTTP reference and it seems simple enough. You can send a HTTP request, get the status code, then get the Location from the response header. Everything I need without having to load any web pages in IE.

I don't know if the status code will actually return 301 if the redirect is working, because I think it might follow the redirect and then return 200, but the if the Location in the header is different to the URL you use in the request, then I think it's safe to assume you are being redirected.

That said, I haven't even typed a single letter of code yet so I'll try to report back when I get round to making this.

Thanks,