Forum Discussion

WLLIAN's avatar
WLLIAN
Brass Contributor
Sep 29, 2024
Solved

EXCEL CLOSE WHEN DONT FIND IMAGE

Hi, i have a file that load multiple image by name on a column. But when don't find the image file... the file close him self. The file and the folder with the images are in the same place. There ...
excel
Macros and VBA
office 365
  • Harun24HR's avatar
    Harun24HR
    Sep 29, 2024

    WLLIAN To avoid this situation you can check if the file exist or not. Use DIR() function to check it.

    If Dir(rutacompleta) <> "" Then

     See the attached file for full codes.

WLLIAN's avatar
WLLIAN
Brass Contributor
Sep 29, 2024

Harun24HRIt works!! Perfect! Thank you.

The botton who actives the code erase after is complete, i notice now.

There's a way to not arase him after run the code?

 

 

 

Harun24HR's avatar
Harun24HR
Bronze Contributor
Sep 29, 2024

WLLIAN Glad to know it helps. In your there is a name of shape which will not be deleted. So, rename your command button name as per name in code. I can't check that name right now as I am writing from mobile.

  • WLLIAN's avatar
    WLLIAN
    Brass Contributor
    Sep 29, 2024

    Harun24HR  its true. I put the name of "imagen2" ... so when i run the code... the botton don't arase now.
    Dude... you are awesome. Really.

    Thank your your time.

Resources