Forum Discussion

ohm_1960's avatar
ohm_1960
Copper Contributor
Aug 15, 2020

Download images inserted in an excel sheet

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).

    • ohm_1960's avatar
      ohm_1960
      Copper Contributor

      HansVogelaar  

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

       

Resources