Renaming excel file

No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information. Not enough pictures. Any additional feedback? Submit feedback. Scripts skip those files. Is there a way to modify the script so it adds a number 1, 2, 3 and so on for every duplicate name? Hello, Kay, To rename the files based on duplicate new names with name-1,name-2, the following VBA code may help you, please try it.

Value If Not xDictionary. Exists xVal Then xDictionary. Add xVal, xCount Else xDictionary. I am following the same process but couldn't succeeded in renaming the file i am also changing "A:A" and "B". Is there any other valuve which i need to change in the code. I cant understand with range A:A or B how to define that, thank you. Hi, Dee, As the note remind, the reference A:A indicates the old filenames list you want to rename, and reference B contains the new filenames that you want to use , as following screenshot shown: Hope this can help you, thank you!

I would like to rename multiple files from folders and subfolders. This is game changing. To rename the multiple files you can also check a software. Search on google- BatchRenameFiles Tool. Check the first search result. Thanks Jonathan F. I tried it for excel, it changes file type. Can you please provide me code for csv files rename. Thank you so much sir, God bless you! Hi, I have more than excel files which I have downloaded from a system and kept in the folder.

Please suggest a macro that can work in this way. Is your task already Solved. I can help if still unsolved. Pls mail me your task. Tx Franz. I successfully used the above instructions last year to rename files in half-a-dozen folders.

Back to English. Log in. Remember Me Forgot your password? Password Reset. Please enter the email address for your account.

A verification code will be sent to you. Once you have received the verification code, you will be able to choose a new password for your account. I'm so glad that you found that useful. Thanks for the feedback.

Re: Renaming Linked Excel Files bump Re: Renaming Linked Excel Files. User Menu Login Registration. Your browser has JavaScript disabled.