Grabbing Image Url

[deadmanramsey]

While working on my TV show spreadsheet, I was wondering if I could utilize some sort of formula for grabbing image urls. For each TV show season, I have a hyperlink that takes me to the products Amazon page. What I am hoping to do is pretty tricky:

Is it possible that given the link, that I can obtain the image url shown on that page? For instance, I have a hyperlink for Trailer Park Boys Season 7. When I click it, it takes me to the following URL :

http://www.amazon.com/exec/obidos/AS...dvdcomsales-20

Once on that page, I am hoping to copy the image url of the main photo and paste it into a new cell.

Not sure if this is possible, but some of the Excel gurus might be able to tackle this. Any help would be much appreciated!

[deadmanramsey]

Let's say that the hyperlink is in cell A1 and I wanted the Image URL for that show to be in B1...

[Ron Coderre]

It's certainly possible...however, Amazon.com web pages are rife with images and they all have cryptic, non-intuitive names. If you have a way of identifying the image name formulaically or with VBA code, please share it with us and we'll see what we can do.

[deadmanramsey]

Hmmm...I'm a little out of my depth here. I was hoping that Amazon would sort their image urls based on predictive wording. I actually got the links as part of a copy and paste from another website. The link includes the ASIN numbers if that helps. Perhaps there is a way to track down an image attached to each ASIN number?

[Ron Coderre]

In the URL you posted, the ASIN is: B0014WAAE4

On that web page, that number appears dozens of times. Here's a small sample of the code:

<div id='main-image-caption' class='tiny'>&nbsp;</div><div id = 'thumbs-image' class='thumbs bottom' customFunctionName = 'ImageBlock.TwisterReArchModule.getAltsImageMarkup'><a href='http://www.amazon.com/gp/product/images/B0014WAAE4/ref=dp_otherviews?ie=UTF8&color_name=x' class='altThumb' target='AmazonHelp' onclick='return false' /><img class='border thumb0 selected' src='http://ecx.images-amazon.com/images/I/51XywMcPdVL._SS30_.jpg' data-index='0'></a><a href='/gp/customer-media/product-gallery/B0014WAAE4/ref=cm_ciu_pdp_images_0?ie=UTF8&index=0' class='ciuThumb'><img class='border thumb1' src='http://ecx.images-amazon.com/images/I/61ExOZ2ZPtL._SS30_.jpg' data-index='1'></a><a href='/gp/customer-media/product-gallery/B0014WAAE4/ref=cm_ciu_pdp_images_1?ie=UTF8&index=1' class='ciuThumb'><img class='border thumb2' src='http://ecx.images-amazon.com/images/I/61xV7T0uDuL._SS30_.jpg' data-index='2'></a><a href='/gp/customer-media/product-gallery/B0014WAAE4/ref=cm_ciu_pdp_images_2?ie=UTF8&index=2' class='ciuThumb'><img class='border thumb3' src='http://ecx.images-amazon.com/images/I/51AHSp8gSEL._SS30_.jpg' data-index='3'></a><a href='/gp/customer-media/product-gallery/B0014WAAE4/ref=cm_ciu_pdp_images_3?ie=UTF8&index=3' class='ciuThumb'><img class='border thumb4' src='http://ecx.images-amazon.com/images/I/51Fbc5nFgVL._SS30_.jpg' data-index='4'></a></div>

[deadmanramsey]

So I guess the question is, is there some sort of constant that can be predicted for each product image? What I am trying to do is have the image url inserted into the spreadsheet, which can then import the image onto a website once the excel file is uploaded. I tried the following url which didn't work :

http://www.amazon.com/gp/product/images/B0014WAAE4

The actual url that would work is :

http://ecx.images-amazon.com/images/...VL._SS500_.jpg

I just don't know how the two can be associated and integrated into some sort of formula. I'm really not that familiar with this type of stuff on Excel : (

[Ron Coderre]

The short answer is: They can't.
The image url is:

Please Login or Register  to view this content.

Amazon has millions of images in its libraries and its web pages are built dynamically when accessed. As with most databases, objects are identified by unique identifiers. Descriptive names are associated with them when implemented on the web page. Consequently, you'd need to know the image name before you can try to download it.