Extract Data from SHTML Table

[kingsdime29x]

Hello,

I am trying to pull data from a table on Baseball Reference and I am unable to get the data to pull. Not sure if this is because the website has a table with a site that ends in .shtml. I have included my workbook and the code below for what I am using. When I try to run the code I can't get any data to generate. Can someone help me out as to why nothing will generate for me? I appreciate the help. Thanks in advance!

Please Login or Register  to view this content.

[sandy666]

I tried url from your code
https://www.baseball-reference.com/boxes/" & ID & ".shtml with ID : SLA/SLA190904140

https://www.baseball-reference.com/b...90904140.shtml in browser and I got one small table... is that what you want or something more?

but with https://www.baseball-reference.com/b...03240LAL.shtml - error 404 (first ID from your list)

maybe check this one: PowerQuery Baseball

[kingsdime29x]

I am looking to get the small table to show up as a value within my workbook. I have done this with other sites and able to pull up the data but for some reason I cannot get this table to pull the data within Excel. The second URL that you tried is irrelevant and I removed it to prevent any confusion. Any help so that I can pull this data would be very helpful and appreciated.

[sandy666]

you've two IDs there in DV
one ....40 works but second ....50 doesn't
you need to check your IDs before put them to the list

here is example tables from your url for the first ID

PowerQuery is required to see how it works. There is no any VBA or formula (I didn't touch yours)

Power Query for

• Excel 2010 Pro Plus or Excel 2013 Pro Plus can be downloaded as free add-in from MS site (choose correct version). I suggest Power Pivot also
• PowerQuery works with M-language and does not contain any classic formulae or vba code
• What is PowerQuery? see here: Getting Started with PowerQuery (Get&Transform) in Excel

you post your problem in thread wich is not yours ... my link to there was to show you example file