O'Reilly logo

Business Analysis with Microsoft® Excel, Second Edition by Conrad Carlberg

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 Parameterized Web Queries

Creating Parameterized Queries in Microsoft Query” earlier in this chapter showed how you can create queries that have one or more parameters. A parameter prompts you for a selection criterion that must be met by any records it returns to Excel.

Microsoft Office comes with some Internet query files, which have the filename extension .iqy. These queries also have parameters, which make them handy for returning from the Web information about companies you specify.

To use an Internet query, follow these steps:

1.
Choose Data, Import External Data, Import Data. The Select Data Source dialog box appears as shown in Figure 18.21.
Figure 18.21. Use the Select Data Source window to invoke any existing database or Internet ...

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