MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Web query question

  Asked By: Jody    Date: Jan 04    Category: MS Office    Views: 1335

I have created a web query to download table realating to a number of companies.
When i run the query i have to either type in the company identifier name or
point to a cell where the identifier is stored.Can i get excel to run down a
column containing company identifiers and automatically pass it to the webquery.



1 Answer Found

Answer #1    Answered By: Bohdana Nonob     Answered On: Jan 04

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.

Didn't find what you were looking for? Find more on Web query question Or get search suggestion and latest updates.