Posted on another forum with no responses ...

I'm using Excel 2003 on Windows Vista.

I've managed to figure out a web query taking parameters from cells. Specifically, the .iqy is

WEB
1
http://www.omdbapi.com/?t=["t",""]&y=["y",""]&plot=short&r=json

Selection=EntirePage
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False
the parameter spec for both parameters says "get the value from the following cell" and "refresh automatically when cell value changes", and the cell specs are

t: =Sheet1!A5
y: =Sheet1!B5

So far so good -- I get the result. But I need to fill down so that the query operates on A6/B6, A7/B7, etc, for maybe 100 rows. If I "fill down", it doesn't fill the web query at all, just the data already returned. If I copy/paste, it does copy/paste the query, but does not change the source for the parameters, leaving them at A5/B5 even though there are no $s in the cell specs.

Is there any way I can persuade Excel 2003 to duplicate the web query AND change the parameters without using VBA? Or do I have to dive into VBA and alter the Connection explicitly?

Edward