web to variable
 

Anyone have any ideas how I could use an excel VBA macro to detect if
web page has changed or not?
I have thought of somehow downloading the source code and sticking i
into a variable, then doing the same again shortly after and comparin
the two. (don't know how mind you)

Any ideas? I want to do this in the simplest way possible really, but
would be happy with any solution

--
Message posted from http://www.ExcelForum.com

web to variable
 

*bump*

Any ideas at all..

--
Message posted from http://www.ExcelForum.com

web to variable
 

You are correct about storing it to variable and comparing on each
download. As to downloading the HTML source, take a look at
http://www.ostrosoft.com/oswinsck/oswinsck_vba.asp

hs234


On Fri, 23 Jul 2004 15:32:08 -0500, Mr Lazy
wrote:

Anyone have any ideas how I could use an excel VBA macro to detect if a
web page has changed or not?
I have thought of somehow downloading the source code and sticking it
into a variable, then doing the same again shortly after and comparing
the two. (don't know how mind you)

Any ideas? I want to do this in the simplest way possible really, but I
would be happy with any solution.


---
Message posted from http://www.ExcelForum.com/