Create a Web query parameter query

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.

You can edit a Web query so that it prompts you for variable parameters. For example, a Web query that gets stock quotes from a Web page can prompt you for a parameter, such as a stock symbol, each time you update the data. You can create a Web query parameter query only from a saved Web query file (.iqy).

  1. In Windows Explorer, navigate to the query file on your computer.

  2. Right-click the file, and then click Edit with Notepad. The query opens in Microsoft Notepad, where you can make changes to the file.

  3. In the text of the file, find the URL of the Web address from which the imported data originated. For example:

At the end of the URL, type the following (do not insert a space at the end of the URL):

?SYMBOL=["Parameter", "Prompt"]

For example, type:

?SYMBOL=["QUOTE", "Enter one or more financial symbols separated by commas."]

  1. On the File menu, click Save, and then exit Notepad.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.