Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 172
Default 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 =---
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert $ to actual numbers in an imported web query Alex Excel Discussion (Misc queries) 1 December 13th 09 03:14 PM
GIF image on web-page corrupts data fetched with Web Query Geoff Lambert Excel Discussion (Misc queries) 0 September 6th 06 12:29 PM
Problem organizing text data into new excel page Tony Excel Worksheet Functions 3 October 21st 05 08:19 PM
problem refreshing data query on yahoos jcoudrie0734 Excel Discussion (Misc queries) 0 October 4th 05 12:14 AM
Use SQL statements in Excel VBA to query SQL Server Data Problem Thank You Excel Worksheet Functions 0 November 20th 04 12:45 PM


All times are GMT +1. The time now is 11:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"