To import and refresh information from a Web site:
1. Open Excel 2000, and from the Data menu, select Get External Data, and then New Web Query.
2. In the Enter the address box, paste the full address of the Web site. For example, open the site www.bloomberg.com, which includes a table of various currency exchange rates. The address of the page containing the table of currency exchange rates is http://www.bloomberg.com/
markets/index.html.
3. Click Save Query, and type a name for the query.
4. Click Save, and then click OK.
5. In the Returning External Data to Microsoft Excel dialog box, click OK.
To refresh the Internet data (the Web site does not have to be open):
1. Select the cell in the sheet containing the data.
2. From the Data menu, select Refresh Data.
OR
Display the External Data toolbar and click the Refresh Data icon. To display the External Data toolbar, select one of the toolbars, right-click and select External Data, and click OK.
To automatically refresh the Internet data:
1. On the External Data toolbar, click the Data Range Properties icon.
2. Select the Refresh every option, and set the number of minutes between each refresh action.
3. Select the Refresh data on file open checkbox to automatically refresh the data when the file is opened.
To run a saved query:
1. From the Data menu, select Get External Data, and then Run Saved Query.
2. Select the saved query, and click Get Data.
Screenshot // Getting Continuously Refreshed Data from a Web Site in Excel 2000
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
"This message is a little late, but maybe it will help someone else...
I went to the web site i want to pull data from and then selected ""view source"" after Right Clicking on the page.
Then I searched for header of the table of interest going ""down.""
Then i searched for ""table"" going ""up"" and counted the number of values i saw, disregarding all the
values i saw.
It worked.
Buenos Suerte!"
"hi. seems excel 2002 (office xp) resolved this issue vs. older versions...
you can indeed, when doing a web query, simply ""v-check"" the tables you want to query from excel
in excel 2000 however, if you want to select specific tables, you are supposed to enter the number of each table on a page for them to be retrieved ...
how in the world is anyone supposed to do that? trial and error is not acceptable... is there another way to find a bloody table number?"