Scraping/Importing Table

Hi all,

I've been struggling with this, and wanted to see if someone might have a solution. I'm looking to import the lap by lap leaderboard at this address:

http://www.nascar.com/en_us/sprint-c....raw_feed.html

Of course, the table can't be imported automatically as Excel doesn't recognize it as a table so it requires a macro for sifting through the HTML. However, I'm fairly inexperienced with VBA currently and haven't been able to create a working macro for this purpose.

It appears the table I want to grab here has the "pqrStatistic" id


I would really appreciate any help with this. Thanks!


Luke

Thanks Marvin for letting me know about this! Really awesome add-in. I'm kind of disappointed, the solution was almost too easy!