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

Please Login or Register  to view this content.
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