| View previous topic :: View next topic |
| Author |
Message |
arsenal123gunners
Newbie
Joined: 24 Jan 2011
Posts: 3
|
 Posted: Sat Jan 29, 2011 2:57 pm Post subject: How to retrieve all data on a web page in Macro |
 |
|
Hello, I am using the following macro to pull data with paramters from http://hoopdata.com/player.aspx?name=Kobe%20Bryant ... (Kobe is just an example page)
| Code: |
Sub URL_Get_Query()
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://hoopdata.com/player.aspx?name=[""Player Name"",""Enter name with %20 between first and last.""]", _
Destination:=Range("a1"))
.BackgroundQuery = True
.TablesOnlyFromHTML = True
.Refresh BackgroundQuery:=False
.SaveData = True
End With
End Sub
|
However it doesn't return all of the statistics, only the headers, such as "Basic Stats", "Advanced Stats" ,etc. no data at all.
Any way to actually get the stats of all of the tables on the page?
[/code] |
|
| Back to top |
|
 |
elg
General User
Joined: 29 Jan 2011
Posts: 6
Location: Oslo
|
| Posted: Sat Jan 29, 2011 4:46 pm Post subject: Re: How to retrieve all data on a web page in Macro |
|
|
| I really hope somebody in the know will tell us the solution. I have been trying to find a way to automatically feed Web data to Calc for a long time. |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
|
| Back to top |
|
|
elg
General User
Joined: 29 Jan 2011
Posts: 6
Location: Oslo
|
| Posted: Sun Jan 30, 2011 4:20 pm Post subject: Re: How to retrieve all data on a web page in Macro |
|
|
Thanks for the pointer to your 'arealink.ods' file, Villeroy.
It may be a start - I shall study it and scratch my head for a while. |
|
| Back to top |
|
|
|
