web search with excel data

  • Thread starter Thread starter Mike Malaier
  • Start date Start date
M

Mike Malaier

I have a list of book titles in an excel sheet and would
like to write a macro that would take the title from a
cell and enter it into a web search engine to get more
infomation about a selection.
getting the selection into a variable would be easy, is
there a way to get that text string into a web search?
 
This will depend entirely on how the search engine works.

For example, if you were using google to search for the book 'SQL for
Smarties' you could construct then navigate the following URL:

http://www.google.com/search?q="SQL+for+Smarties"

However, such and approach isn't very 'interactive' ('interactive' and
isn't even guaranteed to return information about books!) You may want
to find a site which provides an XML web service with which you could
use Microsoft Office XP Web Services Toolkit to browse information
about books. For example, try this link:

http://www.amazon.com/gp/browse.htm...TF8&node=3434621&no=3435361&me=A36L942TSJ2AJA
 
Back
Top