View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ardus Petus
 
Posts: n/a
Default Importing Data via Web Query - Can values be passed to query?

=HYPERLINK("http://www.someUrl.com/loadDate"&"?"&Feuil1!A1&"="&Feuil1!B1)

HTH
--
AP

a écrit dans le message de news:
...
I'm trying to construct a template in Excel 2003 that'll load data via
a web query. Sheet 1 will contain the parameters and Sheet 2 will
contain the data retrieved via a query. Consider the following:

Sheet 1:
A B
1 Country US

Sheet 2 Web Query:
http://www.someUrl.com/loadDate?country=Sheet1!B1

Is this possible?

-johng