ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   excel web query problem, data not on actual page? (https://www.excelbanter.com/excel-programming/289031-excel-web-query-problem-data-not-actual-page.html)

Enjoy Life

excel web query problem, data not on actual page?
 
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

Bob Phillips[_6_]

excel web query problem, data not on actual page?
 
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




Nigel[_8_]

excel web query problem, data not on actual page?
 
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 =---


All times are GMT +1. The time now is 05:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com