Importing Data via Web Query - Can values be passed to query?
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
|