K
kaiser
Hello
I have a spreadsheet with a list of DVD names in Col A.
I would like to know if it is possible to have a web query that
connects to an external site in which you can type the movie name and
it tells you the main actors of the movie, as well as other facts.
www.imbd.com is the site. you can see i can search for varous movies
and it gives in the movie info in a consistant format.
Ideally i would like to use the web query like a formula, with the dvd
name in col a as the variable and the output being the actors name
from the web, in col B. Because i have 400 dvds, i cant create the
link to the site individually but am hoping that the query will allow
me to take the variable from col a and put it into the search box of
the www.imdb.com site, and then have the result returned to col b
Is this possible?
I have a spreadsheet with a list of DVD names in Col A.
I would like to know if it is possible to have a web query that
connects to an external site in which you can type the movie name and
it tells you the main actors of the movie, as well as other facts.
www.imbd.com is the site. you can see i can search for varous movies
and it gives in the movie info in a consistant format.
Ideally i would like to use the web query like a formula, with the dvd
name in col a as the variable and the output being the actors name
from the web, in col B. Because i have 400 dvds, i cant create the
link to the site individually but am hoping that the query will allow
me to take the variable from col a and put it into the search box of
the www.imdb.com site, and then have the result returned to col b
Is this possible?