Ani
03-07-2018, 03:24 AM
I need a VBA code that renames all files within a chosen folder and/or within its subfolders that match given extension/s that i may give in cells or in code array like:
extensions = Array("jpg","png","bpm")
Files new name must match parent folder name.
i also have to give it an name extender like:
extender = "_" + cstr(counter)
where counter in this example is used to count files to be renamed in that folder.
names for all images in subfolder "FName" after code is runned must be:
FName_1.png
FName_2.png
FName_3.png
If the code runs again in the same folder i want it to skip (not change) already named images only search if there are new ones to be renamed and set counter to respective value for that folder.
thank you for viewing/reading this post
Thank you in advance for your help
extensions = Array("jpg","png","bpm")
Files new name must match parent folder name.
i also have to give it an name extender like:
extender = "_" + cstr(counter)
where counter in this example is used to count files to be renamed in that folder.
names for all images in subfolder "FName" after code is runned must be:
FName_1.png
FName_2.png
FName_3.png
If the code runs again in the same folder i want it to skip (not change) already named images only search if there are new ones to be renamed and set counter to respective value for that folder.
thank you for viewing/reading this post
Thank you in advance for your help