PDA

View Full Version : Checking URL's



Ott83
04-08-2012, 08:06 AM
Hi all :hi:

My name is Nev and I'm a complete newbie to VBA, I am looking desperately to find a code that will check a large number of URL's in a spreadsheet, to whether they are active links or not.

I have attached a sample document, and wondered whether anyone has a code to be able to check both columns containing links.

Any help would be greatly appreciated.

Nev

Crocus Crow
04-08-2012, 11:40 AM
For each URL, send a GET request with the XMLhttp object. Its Status property contains the http status code of the response. Google the terms mentioned and you should find examples. Similarly, search for something like 'VBA loop through cells in column' to loop through the URLs.