Thread
:
Importing Data via Web Query - Can values be passed to query?
View Single Post
#
2
Posted to microsoft.public.excel.misc
Ardus Petus
Posts: n/a
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
Reply With Quote