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

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

Importing Data via Web Query - Can values be passed to query?
 

Thank AP,

This enables me to build a link within a Spreadsheet; however, I'm
trying to use the dynamic link to load external data via the Data -
Import External Data - New Web Query utility. I could not dynamically
construct the URL.

-johng

Importing Data via Web Query - Can values be passed to query?
 

Was going to ask the exact same question as you John. Would love to know if
this is possible. Can't find the issue being discussed earlier.

/Mitch

" skrev:

Thank AP,

This enables me to build a link within a Spreadsheet; however, I'm
trying to use the dynamic link to load external data via the Data -
Import External Data - New Web Query utility. I could not dynamically
construct the URL.

-johng

Importing Data via Web Query - Can values be passed to query?
 

Here is a quick solution with a CommandButton and some VBA code:
http://cjoint.com/?fjsociCanS

HTH
--
AP

"Mitch" a écrit dans le message de news:
...
Was going to ask the exact same question as you John. Would love to know
if
this is possible. Can't find the issue being discussed earlier.

/Mitch

" skrev:

Thank AP,

This enables me to build a link within a Spreadsheet; however, I'm
trying to use the dynamic link to load external data via the Data -
Import External Data - New Web Query utility. I could not dynamically
construct the URL.

-johng

Importing Data via Web Query - Can values be passed to query?
 

Let me clarify my problem. The main data source I want to use with web query
is updated daily and the URL is also changed daily. So I can't use a static
web query and get the updated site.

Well, at least I managed to figure out how the URL is named and this info is
available in another web query I've done which doesn't change it's address.

So I'm stuck with the info on how the main source names it's URL after
updating it but I can't figure out how to make the web query for it with the
URL being dynamic, albeit existing in a cell already.

Example:

First I web query one site and get a number which is changed daily, today
its 131.

ok, so know I want to use this number (represented by the XXX) to get data
from a site with thte following URL:

http://www.domainname.com/website/html/web/XXX.shtml

I might add that there's several of these that I need to do otherwise I
would have done it manually.

Any help here would be greatly appreciated.

Regards


"Ardus Petus" skrev:

Here is a quick solution with a CommandButton and some VBA code:
http://cjoint.com/?fjsociCanS

HTH
--
AP

"Mitch" a écrit dans le message de news:
...
Was going to ask the exact same question as you John. Would love to know
if
this is possible. Can't find the issue being discussed earlier.

/Mitch

" skrev:

Thank AP,

This enables me to build a link within a Spreadsheet; however, I'm
trying to use the dynamic link to load external data via the Data -
Import External Data - New Web Query utility. I could not dynamically
construct the URL.

-johng