Excel insert multiple image at once rather than doing it one by one

[zillah]

Hi

Yes I know how to do that if all images are located in one folder or one location.

But since images are separated and organized in different folders not one folder.

I have got this excel document and what I am doing to insert images one by one Insert --> illustrations --> Pictures and choose what I want to then isert it then I resize it to fit in its allocated space as per attached snapshot :

https://imgur.com/a/oGwHwJV

The pictures that I have got them are arranged in different folders as per attached snapshot

Question for a faster way can I select more than one image if they are allocated in different folders and insert them as bundle into excel file ?

Thx

 

[Siddharth Rout]

AFAIK, You can import multiple images (in 1 go) only from the same folder. You can use

Application.GetOpenFilename("All image files (*.JPG;*.BMP),*.JPG;*.BMP", MultiSelect:=True)

and then loop through the array to insert the images.

Alternatively you can let the user just select the parent folder (which has all your folders) and then in the code simply loop through all subfolders and insert the images.