VBA to extract tables from multiple websites using cells in url

[irukae]

Hi,
I'm trying to extract tables from websites (approximately 300) and to put them in different sheets. I have already found a macro I can use to use cells value in a sheet to complete the URLs of the website I want to take the tables from but it has the line .WebSelectionType = xlEntirePage. I tried to change it to .WebSelectionType = xlAllTables and other changes but I can't seem to be able to get any tables from the websites. Using the classic web query shows me the tables I want are availlible. The code I use is the following:

Please Login or Register  to view this content.

The value of the cells A2 and A3 of the sheet "data" are, per exemple, 493114 and 607297. The complete URL for the cell A2 would be https://baseballsavant.mlb.com/playe...er_type=batter . It would be very nice if someone could indicate me a way to make this code work for tables. Thank you for your time!

[AB33]

They may appear to be tables. The tables however are generated by JavaScript. If you look at the source page, any word with the table is part of a JavaScript function. Your best bet to seek an API if the owner of the site has one. It might be probable to extract data using JSON parser, but this is going to massive loop code and not even sure if it works as VBA does not have a JSON parser.