Insert batch of pictures into Powerpoint slides sorted by name

[plantpol]

Hi ! I am new at VBA, and I have been trying to find a code to insert a batch of pictures into Powerpoint (2010) slides sorted by name. I found this code on http://www.pptfaq.com/FAQ00352_Batch..._per_slide.htm which works fine but it seems to be inserting the pictures a random order, I want the pictures to be sorted alphabetically by name like I see them when I go into the folder. Here is the code:

Please Login or Register  to view this content.

The file names I want in order are in this format: Image3, Image 4, Image 9, etc.

Thank you so much!

[kev_]

Welcome to the forum
Your file names are the issue
They are being sorted as text 1, 11, 12, 13......2, 21, 22, 23.....3 etc

To remove your issue rename the files to a consistent format..
Image 001.jpg, Image 002.jpg etc

would you like some VBA to do that? (tomorrow - UK)

[plantpol]

Hi !

Yes that would definitely help! Thanks

However, some of my files are not sequential (e.g. sometimes it goes from Image 3 to Image 6) but the image numbers need to stay the same because the user will have to know what the exact image number is.

[kev_]

OK - been busy today. But will post something tomorrow

[kev_]

Sub ReName (see below) works for me
- my sample data has not been cleared from attached workbook
- your file names may have some oddities that you have not mentioned!
- amended VBA TestReName also included in the attached file
- run with {CTRL} K
- amend the folder path first (must end with "\")
- old values are cleared by the VBA each time
- TestReName dumps values to the 2 worksheets but does not rename any files

The VBA looks at all files in the folder (with *.*)

Please Login or Register  to view this content.

If TestReName does what you need you can either:
- run ReName
OR
- amend TestReName

Please Login or Register  to view this content.

If TestReName does not do exactly what you need, then re-attach the workbook with your data and highlight problem names
(there may be extra spaces etc in your file names)

Please Login or Register  to view this content.