• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 23. Working with Lists and Databases > Creating and Using Web Queries

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 new Web Query takes specialized development skills, but you can pull in a surprising amount of useful data using sample Web Query files that come with Excel 2000. For example, you can connect with Microsoft Investor to download current prices for stocks and mutual funds. To browse through the list of sample Web queries, choose Data, Get External Data, Run Saved Query. To display a list of many more samples—stock quotes, currency exchange rates, interest rates, and more, choose Data, Get More Web Queries.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint