View Single Post
 
Old 01-29-2019, 04:42 AM
ganesang ganesang is offline Windows XP Office 2016
Competent Performer
 
Join Date: Jul 2018
Posts: 170
ganesang is on a distinguished road
Default 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
Attached Files
File Type: xlsx Rename_files.xlsx (9.0 KB, 13 views)
Reply With Quote