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.
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
Of course you can. Just make sure you are adding the file extension. in the vide file name was 1 and the extension was .png for you your file extension will be .pdf
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.
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.
@@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, 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
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
I sent the code everyday. if you didn't receive the code yet then there must be a problem. Please Signup here to get the code: bit.ly/SignUpCode I'll be sending the code within 5 Minutes.
Needed a solution immediately on how to solve the issue, seen a 2.39 sec long video, spent 10mins prepping the information. Video mentioned, code of VBA can be found on description. Turns out we need to sign up with email thats after SUBSCRIBING, and apparently we need to wait for an undefined time frame for an email with the code. How does that solve the problem for your viewers immediately?
Code sent. Sorry for the late. Its still manual. I'm working on an automated service. Soon it will be fully automatic and will solve the delay issue. I'm trying my best but i do have some limitations. Hope you understand.
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.
i signed up to get the code. i didnt receive it. way long process to get a code. i just read the below comments , if any one asking means then only you sending the code and replying to them. then why are you asking them to signup and getting their details.?
I've sent the code. I am trying to make the code sending process automated. When its done it will be smooth. There are reasons behind the system but i send the code to everyone who needs the code. There is no holding back. Only problem is that i'm doing it manually so sometimes you need to wait. once i make it automated everyone will get the code straightaway.
@@Excel10tutorial Thank you!! This was such an excellent and easy tutorial! Literally saved me so much time on file rename. My only thing now is that my files were PDF before and now it converted it to a basic file type where I have to choose the adobe program to view each file. How do I make it rename an adobe/PDF file after renaming? Do I have to ensure it has ".pdf" on the file end name?
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?
I watched multiple videos, this was the most useful and got the job done. Thank you for sharing!
You're most welcome.
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
Can we rename pdf files?..how?
Of course you can. Just make sure you are adding the file extension. in the vide file name was 1 and the extension was .png for you your file extension will be .pdf
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.
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
I've signed up Sir, but not received the code
Code sent. Please check
Is that work in subfolder?
All you have to do is think the sub folder is the main.
Just received the google form but no code yet? Please sent me the code. Thank you.
Check now
This has been such a great help to me. I am very glad I found your tutorial. Many thanks.
Great to hear!
Signed up when can we expect code?
Code sent. Please check your email
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 I already registered, when will I be getting the code?
Sent already.
Great Video! Could I please get the code? I never received the email. Thank you.
Sent!
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.
Hello, I signed up but still haven't received the code. Please respond.
Code sent. Please check your email.
i want to rename all files but i have not 2nd folder i have data in excel
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.
Hey thanks for showing us this. I submitted the form but still now code in email. Can you send it?
Sent
Hi, thanks for the video, when can I expect to receive the code please?
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
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.
DIDN'T GET THE CODE YET. WHAT COULD BE THE REASON? EMAIL IS CORRECT
Code sent Please Check.
you are the star. brilliant! I have subscribed to your channel.
Thanks for the sub!
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 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
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, 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
I have signed up using the google form. I have not yet received the code.
Code sent to everyone. 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!
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
I want sort the files as excel sheet sequence can give me any solutions sir
You cant. Your file will be sorted based on the sorting of your windows.
Does this code work on Google Sheets on Mac please?
Sorry. It doesn't work on either Mac or Google Sheets.
need the code urgently. do you manually share the code?
Code sent. Please check now.
Does this run on excel 2011 for mac?
Doesn't work on MAC
will this code work in numbers?
Try it and let me know if you face any problem.
Why 2nd time this code is not working. I run the macro then select the file but nothing is happening....
Because you are missing something. If it works on the first time that the code is OK.
This is excellent thanks for the tutorial 😍 Signed up and waitiing for the code
Awesome! Thank you! Please check your email now.
Thank you for the video! waiting for the code :)
Sent!
Hi, I'm try to sign up for the code, says "file unavailable". Please help
Please try again. Here is the link forms.gle/H27wWWztmm6ezQZv6
Hello. Thank you for the video. Please send the VB code. Thanks.
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.
I've signed up a few days back (october 19th), please share the code. Thank you
I sent the code everyday. if you didn't receive the code yet then there must be a problem. Please Signup here to get the code: bit.ly/SignUpCode
I'll be sending the code within 5 Minutes.
@@Excel10tutorial Hi, filled the form again plus wrote the code myself anf tried it but doesnt seem to be working. can you please help ?
@@SukalpJhawar Send me an email. I'll look into it.
Thanks man for the wonderful video , straight to the point. Perfect, signed up :)
Thanks for your appreciation. Code sent.
Worked like a charm. Thank you.
You're most wwlcome. Please subscribe and be with us.
Needed a solution immediately on how to solve the issue, seen a 2.39 sec long video, spent 10mins prepping the information. Video mentioned, code of VBA can be found on description. Turns out we need to sign up with email thats after SUBSCRIBING, and apparently we need to wait for an undefined time frame for an email with the code. How does that solve the problem for your viewers immediately?
Code sent. Sorry for the late. Its still manual. I'm working on an automated service. Soon it will be fully automatic and will solve the delay issue. I'm trying my best but i do have some limitations. Hope you understand.
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.
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.
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.
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.
Just signed up! When can i expect the code?
Please check email in a few minutes.
Hi, how to rename multiple folders extension ?
What do you mean by folder extension?
@@Excel10tutorial Sorry, I mean the folder 📂 in the desktop. Thank you
I want to rename folder not file, how to do that?
what is a quick way to fill up column B? i know the trick for fill up with numbers sequentially but the file extentsion, it doesnt work
Try the concatinate function
@@Excel10tutorial yes, i figured it out n my own, thanks anyway
Hello thanks for sharing.
Kindly requesting for the codes. Thank you
Sent
i signed up to get the code. i didnt receive it. way long process to get a code.
i just read the below comments , if any one asking means then only you sending the code and replying to them. then why are you asking them to signup and getting their details.?
I've sent the code. I am trying to make the code sending process automated. When its done it will be smooth. There are reasons behind the system but i send the code to everyone who needs the code. There is no holding back. Only problem is that i'm doing it manually so sometimes you need to wait. once i make it automated everyone will get the code straightaway.
Signed up, gave my email, it has been 15mins and no email on the code.
Code sent. Please check now.
I've just signed up and waiting for the code! Thank you so much!
Hope you enjoy it! Code Sent. Please check
Worked perfectly
Thanks
You're welcome!
this is the one I need, thanks bro it works perfectly
Glad I could help
What is the code? I need to do the exact same and this would be super helpful!! Please and thank you!
In the description
@@Excel10tutorial Thank you!! This was such an excellent and easy tutorial! Literally saved me so much time on file rename. My only thing now is that my files were PDF before and now it converted it to a basic file type where I have to choose the adobe program to view each file. How do I make it rename an adobe/PDF file after renaming? Do I have to ensure it has ".pdf" on the file end name?
@@malindatop7198 "Do I have to ensure it has .pdf" Try that and let me know.
Already signed up. Waiting for the code. Thank you very much..
Sent
I have a issue in my list file name 10 comes after 1 instead 9 help me brother
Sort it according to your need on desktop.
Just sign up waiting for code
Sent. Please check you email.
I've already subscribed. Can I get this code too?
Code sent. Please check. Thanks a million for subscribing.
Hi there! I haven't received the email with the code yet. Could you please take care of it? Many thanks in advanced!
Code sent. Pease check your email.
Ive signed up but never received the code. Where is it???
Code sent. Please check email now.
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.
thanks however, i need the code please i hope you can have something automated instead of waiting for your action
Code sent. Please check. I am working on an automated solution. Soon it will be available.
I signup! Can't wait to get the code.
Sent. Please check.
Seems very helpful. Waiting for the code now! :)
Great! But you don't have to wait. Code link is already in the video description.
I waiting for your code but till now not received
Sent. Check now.
Hi
Can you send the code and where I have to sign up
Signup here to get the code: forms.gle/H27wWWztmm6ezQZv6
Hello! I signed up and have not received the code. Thank you!
Code sent. Please check your email.
Please subscribe and here goes the code: msexceltutorial.com/post/How-to-Rename-Multiple-Files-at-Once
I have aready sign up but i didnt get the code
Very cool!!! Just signed up and subscribed to the channel.
Thanks. Code sent. Please check
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
Signed up and waiting for code. Been looking for this ty.
Hope you enjoy it! Just sent codes to everyone.
Nice Tutorial! Unfortunately the code download link is not working
Please check now.
I managed to write the code (I'm not programmer). It get stuck on the first line "Sub RenameFile()"
Send me and email with the screenshot and which operating system are you working on?
This looks very promising I have applied for the code many thanks
Code link in the description.
Using MacOS I got Run-time error '438 - Object doesn't support this property or method
I don't have a Mac. Sorry man. Can't help.
Hello there! Such a helpful tutorial, many thanks! I've signed up the form for the code, waiting for it!
Sent!
Thanks! Signed up and can't wait to get the code.
Awesome! Thank you! Code sent. Please check.
I've sent mail. But didn't get the code yet
Signup here to get the code: bit.ly/SignUpCode
I didn't get the code from the Email, could you please send the code again? Thank you.
Code sent. Please Check your email.
Waiting for the code
Code sent. Please check your email.
@@Excel10tutorial Hi, the code hast arrived at my email, can you send it again. cmenalantigua2@gmail.com or chrismena2@live.com
Done. Thanks for subscribing.
Thanks for the big help of yours.
Happy to help. Please subscribe and be with us.
Hi. Signed up but not received the code. Looks very handy.
Sent!
I just signed. Thanks a lot for the video. Waiting for the code :)
Sent! Please subscribe.
Not received the code
Code sent. Please Check email.
@@Excel10tutorial you're awesome
It really works, Thank you so much.
You're most welcome. Please subscribe and be with us.
Hi there, thanks for the video but the code hasn't yet been delivered to me
Sent. Please check your email.
Hello I have signed up for the code
Great tutorial
Code sent
Why can't I be able to rename pdf documents using the code?
Make sure you are following the instructions correctly.
@@Excel10tutorial Managed to get it right. Thank you so much.
Great
Sir the link to geth the code is not working huhu
Try Now forms.gle/H27wWWztmm6ezQZv6
Just signed up, waiting for the code. Thanks! Great Tutorial :D
Awesome, thank you! Check email now.
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!
Code is not working in mac?
Sorry. It doesn't work on MAC
Hi! How can I get the code?
Signup using the link in the description and I'll send you the code through email.
@@Excel10tutorial done
I haven't received your information. Could you please help me?
It's awesome ,I've signed up and waiting for it to my email ! Thank you so much
Code sent. Please check your email.