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

=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

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

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

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

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