G
got mike?
first part of the question:
it seems to me that the web query works very well for one particular piece
of info, but doesn't work well as a regular function that can be copied,
however i can't imagine it actually being that way.
for instance, if cell A1=1 and cell B1=1, cell C1=A1+B1=2. if i drag/copy
cell C1 down to cell C2, it will add cells A2 and B2. is there a way to do
this with web queries?
here is the specific application... i want to geocode a series of addresses
using the yahoo maps api. i have a spreadsheet with all the normal address
data (address, city, state) which is enough to geocode. i can only get one
cell to pull a web query at a time. how can i replicate this down the column?
second part to the question:
the data from my query is returned as an xml file. all i want is the xml
data plugged into that cell so i can manipulate it for proper formatting.
what excel does instead is split it up into columns and rows instead,
obviously trying to make things easier for me but in fact making it harder.
how do i keep it from breaking up the data?
third part to the question:
same thing, only this time with html instead of xml. i can't seem to get
the web query to get the raw html. how do i get the raw html instead of the
"processed" html as it would appear on a web page?
it seems to me that the web query works very well for one particular piece
of info, but doesn't work well as a regular function that can be copied,
however i can't imagine it actually being that way.
for instance, if cell A1=1 and cell B1=1, cell C1=A1+B1=2. if i drag/copy
cell C1 down to cell C2, it will add cells A2 and B2. is there a way to do
this with web queries?
here is the specific application... i want to geocode a series of addresses
using the yahoo maps api. i have a spreadsheet with all the normal address
data (address, city, state) which is enough to geocode. i can only get one
cell to pull a web query at a time. how can i replicate this down the column?
second part to the question:
the data from my query is returned as an xml file. all i want is the xml
data plugged into that cell so i can manipulate it for proper formatting.
what excel does instead is split it up into columns and rows instead,
obviously trying to make things easier for me but in fact making it harder.
how do i keep it from breaking up the data?
third part to the question:
same thing, only this time with html instead of xml. i can't seem to get
the web query to get the raw html. how do i get the raw html instead of the
"processed" html as it would appear on a web page?