Exporting images from excel

[Kswamy]

Hi All,

I have been presented with an excel document, with image names in one column (e.g. 832005_001), and hyperlinks in another column (http://www.xyz.com/images/product.jpg).

Note: the Image names are not included within the hyperlink. Don't know if this will impact anything, but thought it was worth a mention.

My goal is to export the hyperlinks in the excel document into a folder as images with the corresponding image names. Is this possible to do without manually opening each link and saving it in a document, and manually renaming each picture in accordance with its image name? (as there are over 4,000).

Thanks and much appreciated!

 

[John_w]

Use a For ... Next loop to loop through the cells in the hyperlinks column and call URLDownloadToFile to download each image to the folder, named according to the image names column. There should be code on this forum fairly close to what you need if you search for the terms mentioned.

 

[Kswamy]

Thanks! I will search for the code

 

[Kswamy]

No such luck finding a code to do this. I was able to call URLDownloadToFile but as some of the images were duplicates, they did not all copy as expected.

 

[SamuelS]

Kswamy, any luck figuring out this code? I have been having the same problem and I haven't been able to get anything to work how I want it to. I resorted to importing the picture to excel before realizing I am just stuck with the image in Excel when I need it in individual png files.