Excel URL Check Help

[udt123]

Hey Guys,

I have been searching for the last 2 days and couldn't find anything so I wanted to see if anybody knew how to go about doing this on the mrexcel forums.

I have a list of URLS in my column A of my excel 2007 workbook and I wanted a macro that can

1)Copy the first URL
2)Paste it into the webbrowser (mozilla or IE)
3)scan the website for the words "product not found"
4)If product is not found, to put an X next to the URL.
5)Repeat until all the URLS in the column are checked

Is this possble? Thanks for the help in advance!

 

[AlphaFrog]

For some reason, the web page occasionally needs a little extra time to completely load or else it errors. I added a one second delay and it seems to have cured the problem.

            [COLOR="Teal"]' Look for text on web page[/COLOR]
            [COLOR="Red"]Application.Wait Now + TimeValue("00:00:01")[/COLOR]
            If InStr(IE.document.Body.innerText, _
               "There were no documents that contained all of the words in your query.") > 0 Then
               
               cell.Offset(, 1).Value = "X"

            End If

 

[udt123]

Thank you again for helping me Alpha! I'm really grateful for all the time you spent on helping me. I'll try this out right now. Thanks again!

 

[shopbulk]

Hi Alpha,

Thanks for the info and help, I am following this thread and found very useful to me. I have one question, how to use this on chrome and can I detect urls like http://https//www.webcosmo.com/Mana...ageIdent=447dccda-24ab-43fb-b735-1fbb3d0ae820

Thanks in advance for your help