insert multiple random images

I have asked this on another site week ago with no reply https://www.mrexcel.com/forum/excel-...om-images.html

Hello

I would like to ask spreadsheet user to select a folder on hard drive (using folder picker maybe), then scan this folder including any sub-folders for any image files e.g. .jpg .png

then to select at random an image and place it in a range sized to that range. to complete this a number of times (lets say 12) and pasting selected random image in a separate range insuring it is not a duplicate of any image already pasted.

if possible i would like to be able to exclude some files from possible selection if they contain certain text (example "back" "folder" using wild cards maybe so back1 back2 etc are excluded)

if there is not enough images to complete loop then duplicate should be allowed

i already have a piece of code to insert an image into a sized range which i have pasted below only in the possibility it may help not in an attempt to offer solution to part of my own question

Please Login or Register  to view this content.

hope i have explained well and thank you for reading

original post https://www.mrexcel.com/forum/excel-...om-images.html has received a possible solution i am currently looking at