Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Jody Mills   on Jan 04 In MS Office Category.

  
Question Answered By: Bohdana Nonob   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.

Share: 

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


Tagged: