Copy webdata into excel

[carlleese24]

hi


Could someone help me please

from this address
http://www.xscores.com/LiveScore.do...te=eventFS&sport=1&newState=promptSoccerTable

I am trying to create a macro so it will copy the table from the above website address above into excel. I have tried to import the data but it won't work. Is there another way using a VBA code to get that table into excel automatically.


I would really appreciate it if someone could help me on this problem

Carl

 

[George J]

As kyrgan says, stepping through will help you to understand what is happening. I put a few comments which should also help.

Basically, the code opens the website, then looks to find the tables in the webpage. First table is the header (0), 2nd table is just below that (1) and the 3rd table is the league table.
(easier to see in the web query section - the parts you can tick are tables)

Then we look at each row in the table and split the individual cells from the table into cells in the spreadsheet.