Importing Multiple Images to Non-Adjacent Cells

[Kbeaux]

Hello Master of All Things Excel,
I recently started a job where I need to import 100s of images into specific boxes in a spreadsheet. It's being done manually right now but, you guessed it, is cripplingly slow and boring. I can reformat the spreadsheets easily enough to make the boxes cells of the correct size, but there needs to be spaces and title placards between the photos. This might be easier to do not in Excel but our evil overlords insist on using Excel for the whole document for other reasons. I've found a few toolsets like KuTools that allow me to import large batches, but these seem to only support putting photos into a range of cells. Does anyone know a solution? Either a toolset that will allow me to import batches of photos into select cells or another solution?

Thanks in advance.
-KBeaux

[davesexcel]

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.


To add a file to a post

[Kbeaux]

Thanks, added. Major features cannot be changed like the existence of titles, but formatting could be changed the like the squares vs large cells or stuff like that.
Please let me know if I can add anything else to make this easier.

[davesexcel]

I have changed the workbook slightly, I removed all the shapes and have added code that will insert a picture for you.

The first step is to get your list of files from the folder of pictures.
Save your pictures in a separate folder and then copy the folder location to sheet 1 A1
FileLocation.jpg
PasteToA1.jpg
Add "\*" to the end of the file location
When you have your folder location, click the button and you will get a list of files from that folder.

The worksheet change event code is located in the sheet module.
RightClick Sheet Tab.jpg

It would be a good idea to look at the YouTube clip I made for this located here:Insert Picture From Dropdown

The worksheet module code:

Please Login or Register  to view this content.

Make sure you have the correct folder location in the code:FolderLocation.jpg

Code to Get the file list:

Please Login or Register  to view this content.

Code to delete all the pictures:

Please Login or Register  to view this content.

[Kbeaux]

Wow that is fantastic! Took me a little time to implement it into all the pages on our actual workbook (about 100 photos),
but I actually learned a lot along the way about data validation and module coding which is always a plus.
This is not what I imagined BUT once implemented will not only make things a lot quicker on my end, but also on the end of the photo organizers.
Pretty sure this is better and easier than I thought it would be.

Thanks again for your time, you've made a small company that much more efficient!