Hi,
I've recently made some VBA code to find images saved across multiple directories and then to copy them to another folder location or add them to an Excel spreadsheet. What I want to try and do is to make it so that it can also copy the images into a PowerPoint template; is this something that is possible?
Essentially the spreadsheet has one sheet (sheet 'locations') full of image filenames, which are IDs, (column A) and their file path (column B). I have another sheet (sheet 'main'), this has a column (A) where the user can enter the IDs of the images they want to find. What I want is to have an additional column (B) where they can specify different groupings of IDs (max 12) and then for the VBA to find the images and copy them into a PowerPoint, with a max of 12 per slide and grouping the images based on the data in column B (ideally using this value as the slide header).
I have no idea if this is possible. I've Googled and found examples of how to do it for singular images or to just dump images into PowerPoint, but not seen mention of grouping and arranging the images in PowerPoint.
If it is possible would someone be able/willing to help me?
Thanks in advance for any replies
Bookmarks