Download images inserted in an excel sheet

Copper Contributor

Good afternoon, I do not know if it is the site, but if not or it is, you will excuse me, I have more than 400 images in an excel sheet, I need to automate their "download", does anyone know how to refer to them in vba?

2 Replies

@ohm_1960 

Excel doesn't have a direct way to do that, but one way is to save the worksheet as a HTML file.

This will generate a subfolder with all the images (and other shapes).

@Hans Vogelaar  

Thanks for answering me, I already have them in the folder, I will find some way to take them from there.