Ok here is a quickly made simple program that will check urls in column C. If you decide to add more urls it should go ahead and check the urls that have not been checked yet.
A couple of notes.
This program crawls the internet and pulls the data from a web page. The web page is pulled from the server and takes some time to load. You should ensure that you are allowed to crawl the site you run it on and are not violating any TOS.
I have a line that will select the row as it goes through. If you need this line to be ignored just a put an apostrophe right in front to turn the whole line into a comment.
Do not change the worksheet name or you will get errors. This is to prevent the code trying to run on another workbook.
Be sure to save all Excel work and make backups before running this. If you get any issues with running the code let me know or just google how to enable macros for your version of office.
Let me know if you have any questions.
Thanks
|