Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-29-2019, 04:42 AM
ganesang ganesang is offline Windows XP Office 2016
Competent Performer
 
Join Date: Jul 2018
Posts: 125
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, 4 views)
Reply With Quote
  #2  
Old 02-04-2019, 11:13 PM
ganesang ganesang is offline Windows XP Office 2016
Competent Performer
 
Join Date: Jul 2018
Posts: 125
ganesang is on a distinguished road
Default

Any development guys
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 03:05 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft