View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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