Hi, i would like to scrape http://www.soccerstats.com/ , many leagues.
So i would need to write a code that would scrape ... lets say even all the leagues and put every league table into different sheet in excel.
Unfortunately I have 0 experience in programming so I have many questions which hopefully will lead to myself and others learning vba scraping.
Trying to search something on the internet, i came up with this ...
Let Chilean league be our sample :
Code:
Public Sub MainCode()
Dim appIE As Object
Set appIE = CreateObject("internetexplorer.application")
With appIE
.Navigate "http://www.soccerstats.com/widetable.asp?league=chile"
.Visible = False
End With
Do While appIE.Busy
DoEvents
Loop
Set allRowOfData = appIE.document.getElementById("?How to find the ID for the whole table in chrome page source?")
'What should i put here to get the whole table?
Dim myValue As String: myValue = allRowOfData.Cells(0).innerHTML
appIE.Quit
Set appIE = Nothing
Range("A1").Value = myValue
End Sub
I couldnt find the name for the whole table using page source : (
Also im guessing there is quite a bit missing, but we have a start.