Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Jenna Ryan   on Nov 08 In MS Office Category.

  
Question Answered By: Shelia Wells   on Nov 08

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: 

 

This Question has 15 more answer(s). View Complete Question Thread

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


Tagged: