-
Checking URL's
Hi all
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
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules