I don't use Excel's web query when accessing data via the internet. I
use XML and HTML strings to call web sites and parse data. However, I do
use lists within the workbooks, in my case ISBN'S, to send data, and
then get the return data via web forms. Looking at the way a web query
is executed via VBA I would imagine you could pass each of your criteria
in a similar manner. Where your URL appears in the web query change the
string like so..
"www.rittenhouse.com//product/product.asp?sku=" & sStringData
Use your web address and where you pass your data replace it with a
variable as shown. You can loop through the spreadsheet and pass each
criteria to this way. Hope this helps.