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
hope i have explained well and thank you for reading
Bookmarks