Using internet explorer with Excel and VBA, page not autorefreshing when opened with VBA

I am trying to scrape some data from a page that auto refreshes, or at least auto updates the data to the web page, but for some reason in an instance of IE 9 that has been opened from code in excel, the page is never updated. If I click refresh on IE the page is updated, but then does nothing again. The site will block my IP if I click refresh too often, and I am wanting to check the data every second or two.

I am confused because if I open IE normally, and navigate to the page, the page auto updates fine

Here is the code I am using to open the instance of IE. There are other pages linked to on that page that have constantly updating odds, and these are the ones that dont auto refresh.

Please Login or Register  to view this content.

Any ideas as to what is happening? I have enabled javascript, and added the website to the trusted zone in IE.

thanks

I am guessing that this is an unknown problem, but bump anyway
thanks

doesn't it update at all or are you too quick ?
Sometimes the data isn't there when your readystate=READYSTATE_COMPLETE, so it's better to wait an additional 500ms-1s before reading.

hi, thanks for the replies

berlan, I dont have any data fetch yet, I was just checking the page to make sure that it was updating properly, and found that it wasnt. It seemed wierd, because when I open an IE window manually and navigate to the page, the prices are updated fine. So what is it about a window opened by excel code that would stop the prices from updating?


My plan was to open the page in IE, and then retrieve the ie.document every second or so, and check the data for new odds. But IE when opened by excel never updates the prices.

bsalv, when the page opens, the initial data is there, but then it doesnt update, so in another window I can see that the odds have changed, but in the IE window opened by excel, the original data is still there