+ Reply to Thread
Results 1 to 1 of 1

Having a problem getting html table data

  1. #1
    Registered User
    Join Date
    09-14-2014
    Location
    usa
    MS-Off Ver
    2010
    Posts
    1

    Question Having a problem getting html table data

    Hi,
    I'm trying to grab an html table through vba: http://www.numberfire.com/nfl/fantas...l-projections/

    The table is set up as 14 columns of static html data (player, position, passing yds, etc), and then 3 more columns of data that load based on a list box selection (FanDuel, DraftKings, etc)

    I'd like to generate an excel file that has all the static data, and then all the available additional data. The table html has all the information I want (static data plus stats according to FanDuel, DraftKings, etc) but my code is not picking up this additional data. The code I have right now goes to the website, loops through all the <tr> tags in the relevant table's html, and prints it out.

    Here's my code:
    Please Login or Register  to view this content.
    And here is the html in question:
    img1.PNG

    It gets all the data above the red line, but doesn't get anything below, not even the table's default values. My first thought was that that data loaded slower than the rest, so I tried making the code wait 20 seconds before proceeding, but that didn't do anything. My current guess are that even though the html data has the same "tr" tag, it's in some kind of different class. (I've never dealt with html, so I'm sure I could be missing something) Not gonna lie, I'm pretty lost here


    Any advice would be greatly appreciated. Thank for reading!
    Last edited by zacherypoche; 09-14-2014 at 11:55 PM. Reason: adding description of attached picture

+ 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. pull data to HTML from excel table
    By yrndtn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-22-2010, 04:11 PM
  2. pasting data from HTML table
    By bmccall17 in forum Excel General
    Replies: 3
    Last Post: 01-17-2007, 05:15 PM
  3. Replies: 23
    Last Post: 04-25-2006, 01:10 PM
  4. Replies: 24
    Last Post: 04-25-2006, 01:10 PM
  5. Import External Data > Non-HTML Table
    By Jay637 in forum Excel General
    Replies: 0
    Last Post: 03-09-2006, 12:37 PM

Tags for this Thread

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