Need excel macro which helps to rename the files within the folder

ganesang · #1 01-29-2019, 04:42 AM

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

ganesang · #2 02-04-2019, 11:13 PM

Any development guys

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
need macro to run on all files in folder	srinivas.mj	Word VBA	1	01-25-2018 05:10 AM
Word 2010 Macro to rename Folder in Directory	staicumihai	Word VBA	2	10-28-2016 03:01 AM
Macro to replace SSN in all files within a folder	caj1980	Word VBA	7	09-11-2014 04:17 PM
macro to change name of files in a folder in order	expert4knowledge	Word VBA	5	07-10-2014 03:54 PM
Can a macro rename Excel files based on a cellname?	chrisd2000	Excel Programming	1	06-23-2014 06:50 PM