Import Data from Web

[AndrewKent]

Hi there,

I am trying to import data into Excel from the "Statistics" tab on this link:

http://www.flashscores.co.uk/detail/soccer.php?match=588618&gmt_offset=-3600&tab=1

However I cannot seem to get it to work. All I can import is the data from the first tab. here is my code:

Sub Macro1()

    With ActiveSheet.QueryTables.Add(Connection:= _
        "URL;http://www.flashscores.co.uk/detail/soccer.php?match=588618&gmt_offset=-3600&tab=5" _
        , Destination:=Range("$B$3"))
        .Name = "soccer.php?match=588618&gmt_offset=-3600&tab=5"
        .FieldNames = True
        .RowNumbers = False
        .FillAdjacentFormulas = False
        .PreserveFormatting = True
        .RefreshOnFileOpen = False
        .BackgroundQuery = True
        .RefreshStyle = xlInsertDeleteCells
        .SavePassword = False
        .SaveData = True
        .AdjustColumnWidth = True
        .RefreshPeriod = 0
        .WebSelectionType = xlEntirePage
        .WebFormatting = xlWebFormattingNone
        .WebPreFormattedTextToColumns = True
        .WebConsecutiveDelimitersAsOne = True
        .WebSingleBlockTextImport = False
        .WebDisableDateRecognition = True
        .WebDisableRedirections = False
        .Refresh BackgroundQuery:=False
    End With
    
End Sub

Can anyone help me please?

Kind regards,

Andy

 

[poolhall]

I'm afraid this may not be possible in Excel.

 

[AndrewKent]

Oh right, why wouldn't it be possible?

 

[poolhall]

Web query functionality in Excel is pretty basic and doesn't work well with complex webpages. You may want to try iMacro.

 

[Norie]

Andrew
There is no tab called Statistics on the page that URL leads to.

 

[poolhall]

there's actually Second row, second from the top.

 

[Norie]

Wasn't there last night when I first tried the link and the code.

Which is perhaps one of the main problems with gettting data from a page/site like this.