EXCEL

Do You Question the Web?

"Generally, though, people tend to overlook the option of using the Web as a data source for Excel, be that source the Internet, an intranet, an extranet, or a Web Service. But they shouldn't. Web queries are an easy, yet remarkably flexible and predictable way of bringing data into Microsoft Excel from anywhere on the Web. You can point a Web query at any HTML document that resides on any Web server - or even on a file server, for that matter - and pull part or all of the contents back into your spreadsheet...When you start using Excel's Web queries, you will realize they are almost as limitless as the Web is.

Well Kept Secret

On the menu bar, go to Data>Import External Data. Then, select Import Data to use an existing Web query or select New Web Query to build a new one.



Also see:
Vertex42.com:
Excel Web Query Secrets Revealed


MSDN.Microsoft.com/library
Integrate Far-Flung Data into Your Spreadsheets with the Help of Web Services

Different Ways of Using Web Queries in Microsoft Office Excel 2003


Updating Excel From the Web

And:
Web Queries and Dynamic Chart Data in Excel 2002

[Edited entry from 2/13/2004]




See all Topics