Macro to return JPG image from URL (2 URL's in an IF statement determined by dimensions

Hi all,

Second post on forum, hope to have more luck with this one....need some help with this one.

I have a macro that retrieves images from the web. It is set up in an IF loop to look at one image server, if it finds an image, it returns it, if not it checks an older (far less up to date) image server. The problem I am having is the newer image server (accurate pictures) displays a picture of the words "image not available", so it thinks it has found the image. Therefor it never completes the if loop to check the second server. I need a way to edit the attached macro to look at the URL JPG file dimensions. when there is an image, it is 350x350, the image not available is 325x325. Here are 2 links to demonstrate the image servers. Both are for Item 00059 based on a sales spreadsheet.

No image available:
http://www.famousfootwear.com/produc...es_ib00059.jpg

Correct Image:
http://www.famousfootwear.com/produc...ff_ib00059.jpg


Running Excel 2007

In this case, the if loop never gets past the "shoes" server to the correct image on the "ff" server. The simple answer would be to reverse the order in the if loop, but the "ff" server has so many bad (outdated) images that it has at least a 25% error rate. In my opinion, no image is better than the wrong one.

I really need help with this one...the VP in my group wants this corrected asap. I can attach the spreadsheet or email it to anyone who is willing and able to help.






Here is a look at my code:

Please Login or Register  to view this content.

Hi,

Please upload your file , in order to offer you a proper solution.

Hi,

Please see the code that i have added to your insert picture function to check for the no image file. Hope this helps.

Please Login or Register  to view this content.

Mine is Excel 2007 (SP 2).

In the template that you are displaying the images , I do not see any "No Image" image. All the products are displayed.

Can you give me some data to simulate the no image problem.

I just ran the template with my code and i have none of items showing the "No Image".

Have a look at the images for M department.

Mine is excel 2007 ( sp2). Did you create the "temp" sheet in your workbook ?

Glad i could help.

I hope your VP appreciates your efforts to get this resolved.