The attached workbook contains two macros: Speed_Test; and PasteResults.
The prime purpose of Speed_Test is to open a particular web page which runs a speed test on the connection to my ISP. When The Speed Test is complete, I: copy the result, close the browser, then run the Paste_Results macro.
I am suspicious that there is a reasonably predictable timeframe when the bandwidth is severely compromised, and want to send a documented set of test results to the ISP. With the current approach, this will unacceptably labour intensive. It is my intent to have the two current macros joined by a third which:
- copies the web page that is returned to me by the Speed test; and
- closes the web page.
[/list] I haven’t any idea how to go about this.On achieving the foregoing, I will place the package in a timed loop.
Any guidance will be greatly appreciated.
See the attached module which you can rename to a .bas file and import into your project. Note that two additional references need to be set in order to automate Internet Explorer, which are set out in a comment in the Function. Hopefully you can see how to integrate this with your other code to put the data into the sheet, which I did not examine in detail.
