Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
any idea how to deal with this? trying a web query on this page,
doesn't get the data... http://www.pgatour.com/scoring/leaderboard/r i see the actual data gets taken from here (and programmed in to the previous page, somehow) : http://www.pgatour.com/scoring/leaderboard/ieData/r if i go to that 2nd page in IE, the page is blank (for me at least), but if you view the source, you see the data that goes into the 1st page above (listed as some sort of variables or something?)... anyway, would love to be able to get the data via an excel web query, but have no idea how.. any ideas? thx |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would guess that the problem is because the first page is a page of terms
and conditions, and you have to accept to get to the next page, you can't go direct. Thus, I don't think web query will work for this. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Enjoy Life" wrote in message om... any idea how to deal with this? trying a web query on this page, doesn't get the data... http://www.pgatour.com/scoring/leaderboard/r i see the actual data gets taken from here (and programmed in to the previous page, somehow) : http://www.pgatour.com/scoring/leaderboard/ieData/r if i go to that 2nd page in IE, the page is blank (for me at least), but if you view the source, you see the data that goes into the 1st page above (listed as some sort of variables or something?)... anyway, would love to be able to get the data via an excel web query, but have no idea how.. any ideas? thx |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The first page is public, is the 2nd page a customised page for a registered
user? To access it directly you might need to contact the webmaster at www.pgatour.com Cheers N "Enjoy Life" wrote in message om... any idea how to deal with this? trying a web query on this page, doesn't get the data... http://www.pgatour.com/scoring/leaderboard/r i see the actual data gets taken from here (and programmed in to the previous page, somehow) : http://www.pgatour.com/scoring/leaderboard/ieData/r if i go to that 2nd page in IE, the page is blank (for me at least), but if you view the source, you see the data that goes into the 1st page above (listed as some sort of variables or something?)... anyway, would love to be able to get the data via an excel web query, but have no idea how.. any ideas? thx ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert $ to actual numbers in an imported web query | Excel Discussion (Misc queries) | |||
GIF image on web-page corrupts data fetched with Web Query | Excel Discussion (Misc queries) | |||
Problem organizing text data into new excel page | Excel Worksheet Functions | |||
problem refreshing data query on yahoos | Excel Discussion (Misc queries) | |||
Use SQL statements in Excel VBA to query SQL Server Data Problem | Excel Worksheet Functions |