image/file renaming within "image/file sets"

[yozangwu]

Hello,

I have been looking all through the forums and online and having difficulty getting a macro to rename images into sets. (all files located within one folder) I was not sure if this was possible or not but I thought that this forum would be the best place to start!

Examples:

1234_1.jpg
1234_2.jpg
1234_3.jpg
abcd_1.jpg
abcd_2.jpg
abcd_3.jpg
abcd_4.jpg

I would like to get these named in the following sequence if it is possible:

1234_1_of_3.jpg
1234_2_of_3.jpg
1234_3_of_3.jpg
abcd_1_of_4.jpg
abcd_2_of_4.jpg
abcd_3_of_4.jpg
abcd_4_of_4.jpg

I hope this is enough information to work off of.

[mike7952]

Give this a try. Assumes the sheet name is Sheet 1 and Starting in Row 2 column A

Please Login or Register  to view this content.

[mike7952]

I missed that you wanted to change these in the folder. Try this, change the path to your files.

Please Login or Register  to view this content.

[yozangwu]

Outstanding, quick and worked like a charm! Would it be possible to have a navigation window pop-up to find the folder rather than adjusting the macro?
If not, it is quite alright.

[mike7952]

This will do it

Please Login or Register  to view this content.

[yozangwu]

Exactly what I was looking for! Thank you so much!!

[yozangwu]

Actually I just tried this latest one it seems to be just duplicating the first number:

was:
abc_1.jpg
abc_2.jpg
abc_3.jpg

After running this script I have:
abc_1_of_1.jpg
abc_2_of_2.jpg
abc_3_of_3.jpg

I am looking for the naming to be like:
abc_1_of_3.jpg
abc_2_of_3.jpg
abc_3_of_3.jpg

[mike7952]

Oops this should do it

Please Login or Register  to view this content.

[visha_1984]

Great work mike

[yozangwu]

That is perfect! Thank you so much Mike!