Im using Excel 2003 on Windows Vista.
I've managed to figure out a web query taking parameters from cells. Specifically, the .iqy is
the parameter spec for both parameters says "get the value from the following cell" and "refresh automatically when cell value changes", and the specs are
t: =Sheet1!A5
y: =Sheet1!B5
So far so good. 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.
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
I've managed to figure out a web query taking parameters from cells. Specifically, the .iqy is
Code:
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=Falsethe parameter spec for both parameters says "get the value from the following cell" and "refresh automatically when cell value changes", and the specs are
t: =Sheet1!A5
y: =Sheet1!B5
So far so good. 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.
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
