Macro to Scrape Data from Web Page

[p_schappert]

I am looking to write a macro to cycle through a list of 5-10 URLs (preferably listed in a range of cells) and return a set table (2nd one on the page, consistently named "Table 0" on each page).

The URL is something like: Fantasy Football Statistics - - Week - Sort

It'll be dynamic as I'm hoping to automatically load 2017 stats into the workbook each week (the number of URLs/queries is determined by the number of positions).

The queries don't need to stay live, either...if there's a way to return raw data, that would be great as well!

Any help would be much appreciated!

Thanks,
Patrick

 

[SyedUsman]

Have you tried using Power Query for this?