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).
Bookmarks