+ Reply to Thread
Results 1 to 3 of 3

pass an excel cell value to a web query

  1. #1
    ed
    Guest

    pass an excel cell value to a web query

    I want to pass a value in a cell to a web query via a hyperlink.

    specifically in the query..

    http://www.switchboard.com/bin/cgiqa...=37&image1.y=8

    the value after &T= which is now BOSTON in the example, I want to pass
    the value in cell C3
    in my excel datesheet.

    I need to know how to format C3 so that is passes as whatever value is
    there. I know there is some character or characters to use to format
    C3 so that it's value passes but I can't remember how to do it.


  2. #2
    Tom Ogilvy
    Guest

    Re: pass an excel cell value to a web query

    =Hyperlink("http://www.switchboard.com/bin/cgiqa.dll?SR=&MEM=14&QV=4A0A5AE1D
    2234A92804BF4F13DCAE550l0239D50E51E81943E6303203O0183DD56AF768443EC303203O03
    832F3DAF7684434F303203&LNK=14%3A21&F=&L=smait&T="&C3&"&S=ma&Z=&image1.x=37&i
    mage1.y=8",C3)

    --
    Regards,
    Tom Ogilvy

    "ed" <[email protected]> wrote in message
    news:[email protected]...
    > I want to pass a value in a cell to a web query via a hyperlink.
    >
    > specifically in the query..
    >
    >

    http://www.switchboard.com/bin/cgiqa...=37&image1.y=8
    >
    > the value after &T= which is now BOSTON in the example, I want to pass
    > the value in cell C3
    > in my excel datesheet.
    >
    > I need to know how to format C3 so that is passes as whatever value is
    > there. I know there is some character or characters to use to format
    > C3 so that it's value passes but I can't remember how to do it.
    >




  3. #3
    ed
    Guest

    Re: pass an excel cell value to a web query

    Thanks, Tom. Just what I needed.


+ 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