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

Chapter 28. 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 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 MoneyCentral to download current prices for stocks and mutual funds or up-to-date currency exchange rates. To open any of the three sample Web queries, choose Data, Import External Data, Import Data.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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