How to rename multiple files at once using excel
HTML-код
- Опубликовано: 2 авг 2024
- Changing thousands of filename manually could make you crazy. This is why in this advanced excel tutorial i have showed you how you can change thousands of file name at once using just excel. We are going to use vba code for this tutorial. Lets get started:
-------------------------------------------------------------------------------------------------------------
Learn Excel VBA Here: bit.ly/excelvbacourse
-------------------------------------------------------------------------------------------------------------
Step 1: Extract the file names with extension in column A ( • How to Import Multiple... )
Step 2: Write the name you want them to be renamed with in column B
Step 3: Click on developer tab ( • How to add developer t... )
Step 4: Click on visual basic
Step 5: Click on Insert and then Module
Step 6: Write the code. (Please subscribe and here goes the code: msexceltutorial.com/post/How-...)
Step 7: Click on "run" button
Step 8: Select the folder where you kept all your files.
Step 9: Click OK and Boom. All your files at that folder is renamed.
#Rename #File
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
/ excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
goo.gl/uL8fqQ
Playlists:
Advance Excel Tutorial: goo.gl/ExYy7v
Excel Tutorial for Beginners: goo.gl/UDrDcA
Excel Case: goo.gl/xiP3tv
Excel VBA Programming Course: bit.ly/excelvbacourse
Social media:
Facebook: / excel10tutorial
Twitter: / excel10tutorial
Blogger: excel10tutorial.blogspot.com
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: hubpages.com/@excel10tutorial
I just want to leave a review that the Visual Basic module works great. I was able to rename 70,000 files and the module only had to run for about 20 seconds. On smaller folders of 5,000 files or less, the module renamed the files almost instantly. Thank you so much for this time saver.
Glad to hear that. Please subscribe & share.
it didnt work for me
Sir can you please share the code for me?
Sub RenameFiles()
'Excel10tutorial
Dim xDir As String
Dim xFile As String
Dim xRow As Long
With Application.FileDialog(msoFileDialogFolderPicker)
.AllowMultiSelect = False
If .Show = -1 Then
xDir = .SelectedItems(1)
xFile = Dir(xDir & Application.PathSeparator & "*")
Do Until xFile = ""
xRow = 0
On Error Resume Next
xRow = Application.Match(xFile, Range("A:A"), 0)
If xRow > 0 Then
Name xDir & Application.PathSeparator & xFile As xDir & Application.PathSeparator & Cells(xRow, "B").Value
End If
xFile = Dir
Loop
End If
End With
End Sub@@bryanroinuestro9340
This has been such a great help to me. I am very glad I found your tutorial. Many thanks.
Great to hear!
I watched multiple videos, this was the most useful and got the job done. Thank you for sharing!
You're most welcome.
Thanks man for the wonderful video , straight to the point. Perfect, signed up :)
Thanks for your appreciation. Code sent.
This is excellent - thank you for saving me so much time!!!
Glad it helped!
What a helpful tutorial, many thanks! I've signed up the form & Subscribed to the channel as well, waiting for the code!
Thanks for the sub! Code sent.
Hello there! Such a helpful tutorial, many thanks! I've signed up the form for the code, waiting for it!
Sent!
It's awesome ,I've signed up and waiting for it to my email ! Thank you so much
Code sent. Please check your email.
This video was very helpful. Keep up the good work, patiently waiting for the code.
Glad it helped. Code sent to everyone who signed up using the link in the description.
Boss! must say you're magician. you saved big amount of my time for renaming 2200 files. it work magically! Thank you!
Glad it helped! Please subscribe and be with us.
Nice, looking very helpful, I've just signed up and waiting for the code to try how much powerful it is.
Hope you enjoy it!
Thank you so much, it was an excelent tutorial and it works
Glad to hear that. Keep watching and keep sharing.
I've just signed up and waiting for the code! Thank you so much!
Hope you enjoy it! Code Sent. Please check
Hi, thanks for the wonderful video and code. Found some problem with the code from my side. After updated to Excel 2016, the Application.Match is no longer available, so it fail to match my original file and rename it. Do you have any solution on this?thanks
Thank you for the video! I just requested the link through the Google form. Thank you!
You got it!
this is the one I need, thanks bro it works perfectly
Glad I could help
So grateful for this. God bless!!
Glad it was helpful!
Hi, thank you for this amazing tutorial :) waiting for the mail now!
Sent!
Just signed up, waiting for the code. Thanks! Great Tutorial :D
Awesome, thank you! Check email now.
Just signed up, looking for code. Thanks! Great video.
Thanks for the comment. Please check your email.
HI this is very helpful. Thank you! God bless
Glad it was helpful!
Thank you so much.. This was really helpful.
Glad it was helpful!
Hello there,
I signed up for your codes, thanks so much for making these videos.
Code sent. Please check your email. Thanks a million for your appreciation.
Thanks! Signed up and can't wait to get the code.
Awesome! Thank you! Code sent. Please check.
Thanks for posting the information! I have subscribed and I'm anticipating an email with the code. How soon can I expect it?
Sent!
Your videos are so simple and very useful. I've signed up too. I need the two codes please
Glad you like them! I've sent the code. Please check your email.
This looks very promising I have applied for the code many thanks
Code link in the description.
It really works, Thank you so much.
You're most welcome. Please subscribe and be with us.
Just give a great comment that even though the post was in 2019 but it is still greatly workable for 2023 with Window 10 Office 365.
Brilliant!!!
Thanks
you are the star. brilliant! I have subscribed to your channel.
Thanks for the sub!
Would it be possible not to have the folder on the desktop? It will only rename if I put the folder on the desktop. It's not that big of a deal, but it would be nice to change if it is a simple fix.
Worked like a charm. Thank you.
You're most wwlcome. Please subscribe and be with us.
Nice video, thanks a lot. I've just signed up and waiting for the code !
Great! Check Now.
This is awesome, I'm all signed up. How long does it usually take to receive the code?
Sent!
hello did you recieve the code if yes then can you send it
subbed and signed up for code! the code i nver knew i needed ! thankyou! waiting for code now :3
Code sent. Check email.
thankyou! but i got the code for a different video. should i apply again in the form?
@@zoyamarie4646 sorry for the mistake. I've sent the mail again. If you still don't get the code just reply the earlier email you've got from me.
Good tutorial. thanks a lot.
Glad you like it...
🙏Thank you for making these types of helpful videos..... N I have signed up for code😊
Code sent. Sorry for being late.
@@Excel10tutorial it's ok...no need to say sorry
Hi :)
the video is quite interesting but I didn't get the code as well till now. Are you sending the procedures yourself one by one or is it an automatic sending once we follow the procedure?
Sorry for being late. I've sent both of the code you requested. Please check your email. And its still manual. Is sent all the email myself.
@@Excel10tutorial no worries mate. I'll check my email tomorrow morning. It's almost 1am here and I'm gonna sleep now :) take care and thanks
Hello, thanks a lot! I just subscribed for the code!
Thanks for the sub! Code sent. Please check email
This is just want i have been looking for, thanks for the video, how do i get the code?
Signup using the link in the description.
Hey, Cool video! I've just signed up and waiting for the code!
Code sent. Please check your email and don't forget to subscribe.
Thanks for the big help of yours.
Happy to help. Please subscribe and be with us.
Very cool!!! Just signed up and subscribed to the channel.
Thanks. Code sent. Please check
Thank you for the video! waiting for the code :)
Sent!
Thank you, perfect!!!
You're welcome! Please subscribe and be with us
Seems very helpful. Waiting for the code now! :)
Great! But you don't have to wait. Code link is already in the video description.
Thank you for the video. I look forward to receive the code from you.
Sent!
I just signed. Thanks a lot for the video. Waiting for the code :)
Sent! Please subscribe.
thank you so much, I sighned up for the Code
Code sent. Please check your email
Worked perfectly
Thanks
You're welcome!
Great tutorial! Just waiting for the code. Would like to know when I’d be able to receive it?
Sent!
@@Excel10tutorial received the code and tried it out. This is truly wonderful! Saves a lot of time. Thank you so much!
You're welcome. Be in touch and share the video.
I have signed up your code, I'm waiting for it to my email, thanks!!
Code sent.
Signed up and waiting for code. Been looking for this ty.
Hope you enjoy it! Just sent codes to everyone.
hi thanks for the video. i need to rename 3k plus files. this will ease my job. have signed up and now waiting for the code. thank you
Code sent. Please check your email. don't forget to subscribe.
Thanks a lot , this was super...
Thanks
I’ve already signed-up bro. waiting for your code. thank you so much
Code sent already. Please check your email and thanks for signing up.
@@Excel10tutorial Hi, I haven't received it yet can you please resend it. thank you so much.
Thanks for the video.
I'm waiting for the code :)
Check now
Waiting for the code, looks like a good video.
Code sent.
I signup! Can't wait to get the code.
Sent. Please check.
Just sent an email. Waiting for the code. These videos are great. Thank you!
Glad you like them! Check Now. Code Sent
Already signed up. Waiting for the code. Thank you very much..
Sent
Signed up already. Waiting for your code...Thanks a lot.
Sent
thank you so much
You're welcome!
Your videos definitely help me the most 😭 Thank you so much.. i have subscribe and i hope i can get the code..
Thanks a million for subscribing. Code is already linked in the description. Please check,
Excellent tutorial
Thank You.
Thank you so much...
You're most welcome
This is very helpful, just requested for codes. I haven't received it yet
Check now
Thanks a lot! Waiting for the email now
Code sent. Please check your email
Just signed up, waiting for code. Thanks! Helpful video.
Great! Check email. Code sent
Bro, Typing original name takes huge time instead we can rename file directly.
My original name is like name of persons.
Please suggest a way to copy original name files in excel.
There are two ways for that and they are as follows.
ruclips.net/video/J9poBn2fJIY/видео.html
ruclips.net/video/bpEtDqbqDTc/видео.html
Hi, thanks for the video, when can I expect to receive the code please?
Code sent. Please check your email.
Good tip, looking for code. Advanced thank
Glad it helped. Code sent. Please check.
Thanks! god bless u ...
You're welcome
It's really great. Can I get the code? It's too needful for me.
Please check your email. Code sent to everyone who signed up. If you haven't already, please signup using the link in the description.
Hello I have signed up for the code
Great tutorial
Code sent
Thanks for for the tutorial.. Signed up for the code. @Excel 10 tutorial
Hope you enjoy it!
Signed up for 2 of your tutorials, awaiting code for
1. Extracting file names, path and ext
2. Renaming the file names
thanks
Sent. Please check your email.
Hi need help, only the file names are not changing once I run the folder in the last step.
Request you to please do guide
Check the code again. Make sure you've correctly added the new names in the sheet and you extracted the old names correctly. If you still have any problem, send me email. Email address is in the channel about section.
Does this run on excel 2011 for mac?
Doesn't work on MAC
Thank you for the this. Waiting for the code
You're welcome! Code sent. Please check your email.
Wow that's awesome! I searched quite a long time for this! I need it to rename files for my accounting folder ([paid date] - [invoice number])
Glad it helped!
Hey thanks for showing us this. I submitted the form but still now code in email. Can you send it?
Sent
Nice!
Thank you! Cheers!
tried this method but says "compile error,syntax error" in a dialog box
what should I do?
Copy the code correctly. You are missing something. If you still get the error then email me.
@@Excel10tutorial Removed the space between each line and it worked.
Thank YOU!
I think if you want more interactions you should put your codes on a portal because not everyone feel safe while submitting info in you google form.
Just a suggestion
Hi I have signed up and given my email 2 days ago and still have not received the code. Just wondering when i can expect it?
It never takes two days. Please signup again or send me an email. I'll resend it
Thanks for the video. Signed up and now waiting for the code.
Hope you enjoy it! Code Sent.
I really like the idea and looking forward to using it. Please forward me the link as I already send a request.
Code sent. Please check your email.
I have one question sir same code will apply for every situation
Yes and follow the instruction as well
Great Video! Could I please get the code? I never received the email. Thank you.
Sent!
Hi, What to do if we have one Image file and needs to give them multiple names. For Example - Image name is A and we have convert it to 10 different file names
First you need to copy the image multiple time and then use this technique.
Does this code work on Google Sheets on Mac please?
Sorry. It doesn't work on either Mac or Google Sheets.
I have filled the google form, but haven't received the code yet? what do I have to do further?
just check your email. Code sent.
Hi, I have signed up a couple of minutes ago with my mail id, no code received yet. Can you please check?
Code sent. Please check email.
Great video! A real time saver! I have subscribed to your channel and donated for this video. Please send me the code for this video. This is the 2nd video I have used.
Sent! Please check your email.
Just signed up! When can i expect the code?
Please check email in a few minutes.
Hi Matera here,
Signed up subscribed looks clean,
waiting for the code.
Check now
Just signed up, waiting for the code, Thanks!
Sent. Hope you enjoy it!
You have excellent tutorials. Thanks you. Would you please email me the code? Or is it possible for me to just enter the code as you have it written in the video?
Sent
@@Excel10tutorial All I see that arrived in my email inbox is a link back to this video.
@@garygaleoldsfamily6520 So sorry for that. Send me a reply of the email and i'll send you the link again.
Waiting for the code. Thank you :)
Sent!
Just received the google form but no code yet? Please sent me the code. Thank you.
Check now