Hi,
Forum newbie but been using VBA for many years. Relevant to the question, my javascript knowledge is near enough to nil.
{https link} telstra-nbn.speedtestcustom.com/
I use CreateObject("InternetExplorer.Application") to successfully open the above link in an Window then objIE.Document.getElementsByClassName(btn)(0). Click to run the javascript that does a speedtest. when it completes, the result displays on a refreshed web page with a new URL. Example:
{https link} telstra-nbn.speedtestcustom.com/result/fe2f9010-48f8-11e9-b436-77ca21305a44
I tried scraping using Data query but that gives me a script error (citing URL {https link} c.speedtestcustom.com/static/js/testBundle.js?v=1551736639632 for the link immediately above). If I continue running, I get an error reporting no data.
Does anyone have a workaround for the problem? Dumping data from the open web page to sheet seems most attractive but I don't know how to do that. Maybe HTML method but I only have table experience using that. Data don't seem to be in table format and I don;t know how to dump the entire content to sheet where I am sure Find would help extract what I need.
Sorry about the slightly obfuscated links. Forum rules say I am not permitted to post web links.
Bookmarks