Get Data From Amazon By sending a product search link from excel???

[keithaul]

I want to create a spreadsheet that will send a product link to amazon.com and have amazon send back certain product information to excel

For example, here is a product link that would reside in the excel spreadsheet:

Amazon.com: Corelle Livingware 16 piece Dinnerware Set, Service for 4, Winter Frost White: White Corelle Dinnerware: Kitchen & Dining

The product details I would like returned from amazon are

current price
In Stock field
Merchant field that says who the product is sold and full-filled by

When I open this sheet daily I would like the VBA code to cycle through all product links in the worksheet, send those links to amazon.com and return to excel the above mentioned product details. Or a button can be created on the sheet to perform when I just mentioned.

Can this be done in excel 2003? if so I would like To know what the VBA code would be to handle this issue. I'm new to VBA and I don't know all the functions, objects, properties etc yet.

If there is training and/or books that you can point me to, that would be very helpful also. If this can't be done in excel 2003, then provide a solution for later versions of excel.

Thanks
Keith