Search HTML source code for text

Hi folks.

I need to check a website daily to see if a link has been updated. If it has been updated, the beginning of the link changes to a different date. Example: today link is www.10212009dave.com and tomorrow link may be www.10222009dave.com. Lets say the link is on www.gugg.com. The link does not change everyday, but I think a good way to see if it has been updated is to search through the source code in the html for that link.

Thus I would put www.10212009dave.com into cell A1 and tell excel to search the source code on www.gugg.com, and if the contents of cell A1 is NOT found, I'd display a message box stating the link has been updated.

Could anyone help me find a way to do this?

OR

Can anyone suggest a better way to check if the link has been updated?

Thanks!

Hello Dave,

This macro will tell you if the link has been updated using the contents of cell "A1". You can change the site to want you want. It is in red font.

Please Login or Register  to view this content.

That seems like what I need, but it is not working. I tried it with the site I am accessing, and also with google and neither worked. I'll post a link of the google example. Not sure if it matters, but IEdoc is set to "[Object]" and Res ends up being 0 each time.

Hello Dave,

The workbok now contains 2 links. One in "A1" and another in "A2". I checked "A1" and it is no longer on the Google page. The link in "A2" is valid. I added a button to call the macro. When the macro is run from the VBIDE, the message box appears while Internet Explorer is active. The message box appears behind Excel while Internet Explorer is active. The message box now is displayed after IE is closed. Here is the updated code. These changes have been made to the attached workbook,

Please Login or Register  to view this content.

Does it matter that the link I'm searching for ends in .pdf? Try it with http://www.mgic.com/pdfs/71-6799_sifi_lpmi_oct09.pdf in A2 and http://www.mgic.com/rates/ratecards.html as the site being searched.

Example below:

Hello Dave,

If the link address exists with in the web page HTML source code, the macro will find it. I have checked the page source code for the link the you provided and it doesn't exist.

You are right. I searched through the source code manually and found instead of writing out http://www.mgic.com/pdfs/71-6799_sifi_lpmi_oct09.pdf, it just has ../pdfs/71-6799_sifi_lpmi_oct09.pfd.

I can make that work, I'll just have to look at the source code every time it changes to find the correct path. Since it only changes about twice a year, that shouldn't be a problem.

Thanks Leith you've been very helpful.
Props

Leith, as discussed:

Hello Dave,

I have run it several times and the results are consistent, even with searches being done with the wireless network running. My system is using Explorer 6.0, perhaps it is a version difference causing the problem.

Ok, thanks so much for your help.