+ Reply to Thread
Results 1 to 6 of 6

Run-time error pulling data from a website

  1. #1
    Registered User
    Join Date
    06-25-2013
    Location
    Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    22

    Run-time error pulling data from a website

    I'm trying to pull some data from a website and I keep getting this error....

    Run-time error '-2147012744(80072f78)':
    Automation error

    It is happening when my code gets to ".send" - i'm not why it is erroring out as it works for another website... any help would be greatly appreciated!

    (I am trying to just get the date at the top "Release Date: September 16,2013)

    Please Login or Register  to view this content.

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: winhttp.winhttprequest.5.1 issue

    Did you try a webquery from this page ?



  3. #3
    Registered User
    Join Date
    06-25-2013
    Location
    Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: winhttp.winhttprequest.5.1 issue

    Thanks for the response snb!

    Yes I tried that first but it will not work as I cannot select the data needed.

  4. #4
    Registered User
    Join Date
    06-25-2013
    Location
    Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Run-time error pulling data from a website

    I'll take one more go at it... anyone got any ideas?

  5. #5
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: Run-time error pulling data from a website

    Hi Smith3rs,

    first of all - your code works fine in my workbook, so I can't tell you why it won't work for you.
    Anyway, try the slightly alternative code below (which also works for me )

    Please Login or Register  to view this content.
    even more alternatively - try this :

    Please Login or Register  to view this content.
    And please - remember the click the * below if this helps
    Please click the * below if this helps

  6. #6
    Registered User
    Join Date
    06-25-2013
    Location
    Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Run-time error pulling data from a website

    Awesome! I'm not sure why it wouldn't work for me but I appreciate the alternative, it works perfectly.

    Thank you very much JasperD!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] pulling off data from website
    By squirrely in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-05-2013, 11:26 AM
  2. Pulling data from a website
    By hockeyadc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-14-2012, 10:39 AM
  3. Pulling off Data from website into excel
    By Lisa4legin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-06-2012, 07:52 AM
  4. pulling data from website
    By Amar Thakkar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-24-2011, 08:05 AM
  5. Pulling data from website
    By inoexcel in forum Excel General
    Replies: 3
    Last Post: 07-28-2007, 07:02 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1