+ Reply to Thread
Results 1 to 6 of 6

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

  1. #1

    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


  2. #2
    Ardus Petus
    Guest

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

    =HYPERLINK("http://www.someUrl.com/loadDate"&"?"&Feuil1!A1&"="&Feuil1!B1)

    HTH
    --
    AP

    <[email protected]> a écrit dans le message de news:
    [email protected]...
    > 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
    >




  3. #3

    Re: 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


  4. #4
    Mitch
    Guest

    Re: 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

    "[email protected]" 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
    >
    >


  5. #5
    Ardus Petus
    Guest

    Re: 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" <[email protected]> a écrit dans le message de news:
    [email protected]...
    > 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
    >
    > "[email protected]" 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
    >>
    >>




  6. #6
    Mitch
    Guest

    Re: 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" <[email protected]> a écrit dans le message de news:
    > [email protected]...
    > > 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
    > >
    > > "[email protected]" 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
    > >>
    > >>

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1