OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

How to retrieve all data on a web page in Macro

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
arsenal123gunners
Newbie
Newbie


Joined: 24 Jan 2011
Posts: 3

PostPosted: Sat Jan 29, 2011 2:57 pm    Post subject: How to retrieve all data on a web page in Macro Reply with quote

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
View user's profile Send private message
elg
General User
General User


Joined: 29 Jan 2011
Posts: 6
Location: Oslo

PostPosted: Sat Jan 29, 2011 4:46 pm    Post subject: Re: How to retrieve all data on a web page in Macro Reply with quote

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
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sun Jan 30, 2011 3:16 am    Post subject: Re: How to retrieve all data on a web page in Macro Reply with quote

elg wrote:
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.

Pardon Question
http://www.oooforum.org/forum/viewtopic.phtml?p=411981#411981
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
elg
General User
General User


Joined: 29 Jan 2011
Posts: 6
Location: Oslo

PostPosted: Sun Jan 30, 2011 4:20 pm    Post subject: Re: How to retrieve all data on a web page in Macro Reply with quote

Villeroy wrote:

Pardon Question
http://www.oooforum.org/forum/viewtopic.phtml?p=411981#411981


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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group