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