Hi, I've been using Internet Explorer automation to do some web scraping for my database. The problem I'm having is that some of the data I need is loaded asynchronously via AJAX so that the data is still loading even after the page is loaded (i.e. after ie.readyState = READYSTATE_COMPLETE).
Is there a way that I can halt execution of my VBA code until all asynchronous data is loaded or all the javascript is done executing? Right now I'm just delaying the program for an inordinately long period of time so that hopefully everything will be loaded by then but it's not a good solution.
Is there a way that I can halt execution of my VBA code until all asynchronous data is loaded or all the javascript is done executing? Right now I'm just delaying the program for an inordinately long period of time so that hopefully everything will be loaded by then but it's not a good solution.
