Creating and Using Web Queries
Excel and your Web browser can work together to gather information from a source on the Web. Microsoft Excel Web Query files are simple text documents that include a pointer to a Web page, plus a few lines that define parameters for the query. When you run a Web Query, Excel opens a connection to the Internet, connects with the specified Web page, executes the query, and returns the data to Excel.
Writing a Web Query from scratch takes specialized development skills, but you can pull in a surprising amount of useful data using sample Web Query files that come with Excel. For example, you can connect with Microsoft Investor to download current prices for stocks and mutual funds. To open any of the three sample Web ...
Get Special Edition Using Microsoft® Office XP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
