ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   External Data from Web "Old School" style (https://www.excelbanter.com/excel-discussion-misc-queries/207263-external-data-web-old-school-style.html)

FT

External Data from Web "Old School" style
 
Is there any way in 2007 to be able to retrieve external data from the
web using the table references (and not by clicking on the little
arrows)?

The reason I ask is...I would like to set up a sheet to retrieve box
scores for an NBA game...but unless the game has started, the url is
not populated with the tables, and I would like to set this up early
in the morning.

Essentially, if I can reference the certain table number, I can pre-
set the query to retrieve that table number for that specific url
before the game even starts.

Let me know if you have any ideas.

Don Guillett

External Data from Web "Old School" style
 

Send me the details to my address below and I will take a look.
I have done programs for betters.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"FT" wrote in message
...
Is there any way in 2007 to be able to retrieve external data from the
web using the table references (and not by clicking on the little
arrows)?

The reason I ask is...I would like to set up a sheet to retrieve box
scores for an NBA game...but unless the game has started, the url is
not populated with the tables, and I would like to set this up early
in the morning.

Essentially, if I can reference the certain table number, I can pre-
set the query to retrieve that table number for that specific url
before the game even starts.

Let me know if you have any ideas.




All times are GMT +1. The time now is 10:09 PM.

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