Results 1 to 6 of 6

Web Query through URL in Cell

Threaded View

  1. #1
    Registered User
    Join Date
    05-18-2009
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2003
    Posts
    14

    Web Query through URL in Cell

    As the title says,

    I've got a cell (using various applications of CONCATENATE) which will always contain the correct URL for my web query.

    So the page would notice by itself that the cell has been changed, and would attempt to do a web query using that url in the cell - whilst submitting the results on the third (empty) worksheet on the first row of the page or so.

    Is that even possible? - And if so, how?

    The link I'll be using for the Web Query is : http://www.nationstates.net/cgi-bin/...gi/nation=XXXX - (try http://www.nationstates.net/cgi-bin/.../nation=unibot for some examples of its feed).

    The box that the current url will always be in is called "Targeturl"

    I've attached the workbook, however the server wasn't working earlier for this. So if anyone wants to see the workbook - I'd be more than willing to email it to them. I don't think its very relevant though, considering it doesn't yet have the code on it.

    Thank You

    ______________________________________

    If this is in the wrong subforum - Sorry. I was unsure on which one was the current one - I was assuming that VB would be needed to solve this problem (if it can be done).
    Attached Files Attached Files

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