O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using a Web Query to Return Internet Data

Web queries let you grab specific information, such as stock prices, sports scores, or your company's current sales data, from the Internet or an intranet. Queries can be set up either to prompt you for the data you want (for stock ticker symbols, for example) or to get the same information every time they're executed. You can try out Web queries using a set of sample queries that come with Excel 2003.

Excel's graphical interface for creating Web queries lets you build a query by pointing to the data you want. You can refresh the query at any time or at regular intervals, and you can save the query in an IQY file for reuse in other worksheets. You do not need to understand how the target Web page is built ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required