Need excel macro which helps to rename the files within the folder
Hi Folks,
I need the macro in excel which helps to rename the multiple files at a time.
I have the 100s of files which needs to renamed as follows,
Type 1: MMK-NJK12345-N-123456-A-12756-00001-A-001-01
Type 2: MMK-NJK12345-N-123456-A-12756-00006-A-001-01
Both types rename sequentially as start number as 00001 or 00006 without affecting inside of the files.
Please see the attachment format of renaming and let me know if any changes required.
Thanks
Ganesan. G
|