Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-29-2019, 04:42 AM
ganesang ganesang is offline Need excel macro which helps to rename the files within the folder Windows XP Need excel macro which helps to rename the files within the folder Office 2016
Competent Performer
Need excel macro which helps to rename the files within the folder
 
Join Date: Jul 2018
Posts: 171
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, 11 views)
Reply With Quote
  #2  
Old 02-04-2019, 11:13 PM
ganesang ganesang is offline Need excel macro which helps to rename the files within the folder Windows XP Need excel macro which helps to rename the files within the folder Office 2016
Competent Performer
Need excel macro which helps to rename the files within the folder
 
Join Date: Jul 2018
Posts: 171
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
Need excel macro which helps to rename the files within the folder 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
Need excel macro which helps to rename the files within the folder 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft