View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TexasAggie2010 TexasAggie2010 is offline
external usenet poster
 
Posts: 1
Default How do i import prices shown on Amazon.com?

I want to create a fully update-able Excel sheet showing prices of movies.
For example with these cells: A1=Blu-ray, A2=I love you man, can I list in
cell B2 the price of the blu-ray movie for "I love you man"? Also I would
like the price from Amazon.com itself and not a reseller on Amazon.

I tried exporting data from internet explorer 8 into excel, but every time I
get an error: line 49, char 1.
I also tried the importing of web queries using the built in web query
importer, but Amazon.com doesn't let me select JUST the price. I don't know
how to modify it to just show the price

Any help would be GREATLY appreciated!