Hi! friends,

I have a question but not sure if this is possible with xl macros.

I have few website addresses in the range B2:B6. Here are they:
http://www.mywebsite/report1.htm
http://www.mywebsite/report2.htm
http://www.mywebsite/report3.htm
http://www.mywebsite/report4.htm
http://www.mywebsite/report5.htm

This is just a sample data, I have in all 50+ urls in my worksheet.
Everytime I visit the first link and check if that report is updated.
If it is updated, somewhere on the page I will get a comment "updated"
to check that, I use CTRL+F function to find the word "Updated" if it
is updated, I put a "YES" in cell D1

Similarly, I traverse through all such links to see which one is
updated. This is a very tedious manual task. Is it possible to
automate this by integrating a browser within excel or opening a
browser and communicating it through excel?

How is VBA/Excel supposed to know if the file has been updated ?

NickHK

"Maxi" wrote in message
oups.com...
Hi! friends,

I have a question but not sure if this is possible with xl macros.

I have few website addresses in the range B2:B6. Here are they:
http://www.mywebsite/report1.htm
http://www.mywebsite/report2.htm
http://www.mywebsite/report3.htm
http://www.mywebsite/report4.htm
http://www.mywebsite/report5.htm

This is just a sample data, I have in all 50+ urls in my worksheet.
Everytime I visit the first link and check if that report is updated.
If it is updated, somewhere on the page I will get a comment "updated"
to check that, I use CTRL+F function to find the word "Updated" if it
is updated, I put a "YES" in cell D1

Similarly, I traverse through all such links to see which one is
updated. This is a very tedious manual task. Is it possible to
automate this by integrating a browser within excel or opening a
browser and communicating it through excel?