Hello! Does anyone know what I may be doing wrong? I'm trying to pull specific data into Excel based on a value in B3 of Sheet 1 (in Excel) using a webquery. The url that I'm using follows this format:
http://(web server name)/ibi_apps/WFServlet?IBIF_ex=(fex name)&(parameter name)='Sheet1'!B3

However, when the webquery is "refreshed" the data doesn't change based on the value in B3.

Any assistance would be greatly appreciated!

when the url is evaluated, does it in fact contain the value in that cell?

yes

I remember this question coming up with a customer of mine, and CSS responded that it is unsupported. Has that changed?

The only way I have gotten this to work is by creating an "iqy" file. This lets you reference some other cell to update a web query.

Thank you for your feedback.

I'm not sure if it is supported or not.

What is a "iqy" file? Also, is this a separate file from the one with the webquery?

Google "Excel WebQuery" and "iqy". It is a separate txt file on your PC that can be imported and used to setup WebQueries in Excel. You can create one by saving any WebQuery, and then edit it.
Here is the text out of one. Only the first 4 rows are important. Especially the fourth line. Once the WebQuery knows you have parameters, the correct dialogs will appear.

 
WEB
1
http://rptdev01.ejgallo.com/ib...?IBIF_ex=tbl_display
&FILENAME=["FILENAME","Type in a Filename"]&OUTPUT=["format"]
Selection=AllTables
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False

After you have imported one (details vary by Excel version), you highlight the cell where the query is attached, right click and pick "parameters". You get a dialog that lets you choose how to satisfy each parameter: by prompting, static value, or choosing a cell that will contain the value.
You should get this without using the iqy file to import, but in practice, I found it hard to get the parameters into the query without it.

This message has been edited. Last edited by: N.Selph,

have a look at this article
http://www.informationbuilders...developers/rcxx.html