Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Capturing data from a web page (VBA/Excel/2000;2003)

    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:

    <UL><LI>copies the web page that is returned to me by the Speed test; and
    <LI>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.
    Regards
    Don

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Capturing data from a web page (VBA/Excel/2000

    This bandwidth test page is a bit of a challenge because it loads two other pages in succession. A moving target. <img src=/S/grin.gif border=0 alt=grin width=15 height=15> 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.

  3. #3
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Capturing data from a web page (VBA/Excel/2000

    Thanks Jefferson

    I'm looking forward to integrating this.
    Regards
    Don

  4. #4
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Capturing data from a web page (VBA/Excel/2000

    Jefferson

    In addition to my previous message; Thank you for the very well commented code.
    Regards
    Don

  5. #5
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Capturing data from a web page (VBA/Excel/2000

    Replacement attachment.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •