The following code has copied a table from a yahoo link for the last few years with no problem. I ran the code recently and instead of the table of players as before I received this message in a cell in my sheet.
“It appears your browser may be outdated. For the best website experience, we recommend updating your browser. learn more”
I tried the code with Google Chrome as my default browser instead of Internet Explorer with the same results.
This is the code:
Private Sub get_data_from_yahoo()
'
' this will query yahoo and get scores for tournament
With Sheets("players scores").QueryTables.Add(Connection:= _
"URL;http://sports.yahoo.com/golf/pga/leaderboard?sort=name", _
Destination:=Range("$U$3"))
.BackgroundQuery = True
.TablesOnlyFromHTML = True
.Refresh BackgroundQuery:=False
.SaveData = True
End With
End Sub
Any thought would be appreciated