Insert / Load Image From Folder To Worksheet With VBA Excel, Fully Automatic

There are times when we use excel files to display images.

The excel file that is used to display the image will have an effect that the excel file takes a long time to open. Especially if the image files are used in large numbers.

To solve this problem, we have to save the image file that will be displayed in a folder, and the image file will be called when we need it. So that the image file does not make the excel file "heavy" and takes a long time to run.

Here are steps to make the process of displaying images in an Excel file easier and lighter to run.

1. Prepare images to be displayed in a folder with Excel files (especially those with the .JPG extension)
2.Create Dynamic Ranges with (File Manager)
3. Creating a Range of "Foto" Names
4. Validation List
5. Making Automation Code Image Name
6. Make Image Call Code as the name implies

Download File Sample:

[Jojosmith]

Thank you very much for your useful tutorial. Liked and definately subscribed !

[mr.write]

Dont do the name manager! Its a messed up features and still buggy. You wont be able to use files manager with other formulas such as match. It wont read the first row. I used to use it and the bug will give you headaches in the future. Use filname manager on simple data validation. If you use it in much complex formulas it sometimes gives you an error. Its better to put your offset values in a cell then use # to get it.