View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marc Marc is offline
external usenet poster
 
Posts: 22
Default Retrieving Amazon product data to excel, namely books!

Boy, this took some searching... try this info:

http://computerbits.wordpress.com/20...n-web-service/

It looks like you can then create a text file for use by Excel (*.iqy) to
query Amazon. Below is an example of an IQY file that is included with
Excel.
===============
WEB
1
http://moneycentral.msn.com/investor...es.asp?SYMBOL=["QUOTE","Enter
stock, fund or other MSN MoneyCentral Investor symbols separated by
commas."]
===============
I imagine you could construct a similar file to query Amazon, then it looks
like you would use "Data/Import External Data/Import Data" to invoke your
query.

Also, check out: http://www.microsoft.com/mind/0298/corner0298.asp for more
info on how to put it all together...