You are getting 3 hours of data and you want to extract one hour of
this time and not get any overlap in the data. Am I correct?


Why can't you run a macro 5 minutes after the hour using a web query.
Then copy only the rows you want to a 2nd worksheet with the combined
data so you don't get any overlap in the data.

I used 5 minutes after the hour because the webpage time and your
computer time may not exactly match and the webpage may not get updated
exactly on the hour.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=204167

http://www.thecodecage.com/forumz