Hi Peterson,

Its working like a charm and you saved a lot of time in file renaming.

I am so very grateful for your time.

I had one more doubt regarding this, in the same way if we want to ADD "_Audited" to all the filenames in a folder, please provide a solution for this...

I had basic knowledge on VBA, i tired to change " strToRemove" this to "strToAdd"



Please help me...

The attached template contains a macro that will add and remove text from file names. There's a small input box to enter text -- to make it easier to specify the string to remove or add -- hence the template file.

Attached Files

BulkRename.dotm (33.0 KB, 13 views)