I've been trying to figure out how to do exactly this literally all day! So many websites and videos made it seem so complicated and used so many more lines of code, and yet what you did is so simple and took hardly any time to do! Thank you so much! P.S. I know absolutely nothing about VBA and was able to get this working in about 10 minutes or so. Don't know how this works, but it gets the job done so can't complain.
This is unbelievable, man, you saved my life. it's so simple to use, download the .xlsm file, choose folder path. assign the names to be renamed, press button finish, The magic happens. :)
Thanks, this is very useful for my job. I always need to rename a lot files in a given order one by one, but now I will use a custom order list in excel and them run this code. It will save me a lot of time.
This is literally game changing code for me... I had over 1,000 files I needed to convert to a different naming system and I thought I was going to die if I had to do it manually... now I just press 3 buttons... Christ this is a miracle!!!
Hi Kamal, Thanks for sharing such valuable knowledge, i also updated the code as you taught, but unable to get the folder path in the bar, like as you have shared a template file , Please advise
That’s a very useful and simple way of doing. Can this done for the sheet of Excel files in a folder. Say like there are 60 Excel Files with single sheet in each of them in same folder and I want to rename the sheet of every excel file. Please make a video for above request Thanks
This macro has a major flaw. If the file is not English characters then the macro will fails. I have to write one additional subroutine to get around that problem.
I successfully did this before but now when I try to run the first part to fetch the names nothing happens. It just brings up a list of macros and ask me if I want ti run it and when I select run nothing happens. I’m not sure what I’m doing wrong, I did exactly what you did in the video.
@Extreme Automation - Kamal Girdher Thanks A lot for such a great video, Its appreciable if u can share Codes for picking Folder path from a specific cell (In my Case "Sheet1"("O5")) in same workbook instead of pre-defined folder path, I tried to get a code for the same from internet, but i cound not make it. Thanks in advance for your support
Hi Kamal, is there a way to possibly modify the macro, so instead of showing only the files names inside the folder, it will show the name of files in the subfolders as well, so when we click on "Get Files Names' it displays all the files names? Thank you very much :)
Thanks for the video. The 2nd coding is not working. It’s shows Run-time error ‘5’; . Invalid procedure call or argument. Any thoughts why it’s not working?
Hi Could you do the video including buttons portion also and fetching names code is perfectly working but renaming code is not functioning and saying run time error.....
You are not defining the variable r here, i think it would be a good practice to define all ur variables. Or do you think it is really not necessary to define variable r??
Thank you for this, however I cannot get it to work. I edited the macro so it points to a folder path where my files are stored and thought that would be all I needed to do, however it isn't working.
First time I run it didn't work, then I realized that when I copied the folder path from the window and paste it in the VB, it didn't show the last back slash "\". It need to have that last back slash in order to work.
Hi, thank you for the video! I was wondering if it would be possible to use folder picker with this video rather than hard coding the file path. Would appreciate if you have such code.
@@xtremeExcel Thanks A lot for such a great video, Its appreciable if u can share Codes for picking Folder path from a specific cell in same workbook instead of pre-defined folder path, I tried to get a code for the same from internet, but i cound not make it. Thanks in advance for your support
Moreover, to my previous comment and after using Name statement. I can say it is unstuck, failing or good-for-nothing. Unpredictable errors or fail to rename files (sure they are not opened, not readonly)
@@xtremeExcel I am sure, can you tell me why one of the following lines work where the other not ? I am programmer (~33 years) for many Languages. and mainly Mech Eng. so I can understand you fast. (.JPG & .jpg work both) Name "D:\Test\660_000010.JPG" As "D:\Test\760_0009.JPG" work Name "D:\Test\660_000010.JPG" As "D:\Test\660_0009.JPG" doesn't work This is one of many Name "D:\Test\660_0008.JPG" As "D:\Test\660_0001.JPG" work Name "D:\Test\660_0000.JPG" As "D:\Test\660_0001.JPG" doesn't work
Thank you so much for this!! This is a wonderful tool. I tried and it worked, however it is converting my PDF to file. How do I keep the .pdf? Thank you!
@@xtremeExcel I am trying to change names of multiple PDF files. When I use the template and change the name, it converts it from .pdf to type: file. When I try to open the file it makes me select the output. I am able to then open it in PDF if I select "Open with Adobe". Is there a way to keep it in .pdf type after changing the name? I hope this makes sense.
Is there a VBA code that can search multiple folders and rename all of the files in the different folders? In column A I have the filepath down to the pdf that I want renamed and in Colum B I have what I want to change the name to.
@@xtremeExcel This is the error: "Name myPath & Cells(r, 1).Value As myPath & Cells(r, 2).Value ". I don't know how to get the screenshot to send to you.
I use this to rename mp3 files when I rip some of my audiobooks. Windows media player can't find the names so I have to rename them. I was able to reformat the names how I wanted but I couldn't get it to add the .mp3 at the end so I had to add it manually. Am I doing something wrong?
It is hard to understand what exactly you have done and what has happened. Can you record a small video of what steps you have performed so that I can see?
I can't believe someone would share such a valuable tool. I am super grateful for this. You are amazing. Thank you very much!
Glad it was helpful! Stay connected! :-)
I've been trying to figure out how to do exactly this literally all day! So many websites and videos made it seem so complicated and used so many more lines of code, and yet what you did is so simple and took hardly any time to do! Thank you so much!
P.S. I know absolutely nothing about VBA and was able to get this working in about 10 minutes or so. Don't know how this works, but it gets the job done so can't complain.
It's just amazing. I spent 3 hrs on some complicated codes. And finally this helped me quickly. Thank you so much.
Glad it helped!
You are a saviour❤️ Thank you so muchhhhhhhh.. So easy to follow and completed task with out any error. 😍
This is unbelievable, man, you saved my life. it's so simple to use, download the .xlsm file, choose folder path. assign the names to be renamed, press button finish, The magic happens. :)
Thank you dear. Stay connected😃😃
I cant believe how come you can be so kind to save the world's time!! Thanks so much mate!!!
First macro runs fine. The 2nd didn't work and kept generating a run-time error.
This is absolutely amazing. I'm new to coding, but I am motivated to learn due to my new job. Thank you for the help!
Thank you for the feedback. Keep supporting.. :-)
Thank you so very much! This is a task that I complete monthly. You have reduced the time in accomplishing this task substantially.
Great!
Thanks, this is very useful for my job. I always need to rename a lot files in a given order one by one, but now I will use a custom order list in excel and them run this code. It will save me a lot of time.
Very much useful tutorial for novice users. It served my purpose easily. Thank you Kamal.
This is literally game changing code for me... I had over 1,000 files I needed to convert to a different naming system and I thought I was going to die if I had to do it manually... now I just press 3 buttons... Christ this is a miracle!!!
Thanks mate !!!
Did what exactly i was looking for... Thanks a lot... Earn a subscriber...
This is life savior. Thanks a lot for this tool
Everything runs very well. Thank you for share with us
So nice of you
Thanks Kamal!! This will save me a lot of time!!
absolutely simple and clear piece of code..! great job.! kudos for this knowledge sharing..!
Thank you for the feedback.. Stay connected! :-)
Thank you very much. It saved my time for renaming a lot of files.
Glad it helped!
I sub'ed.
Great tool & very gracious of you to share the code!
Many thanks, I have been looking for an easy solution. :)
Superb man.. you are too good. Thanks yaar brother..
Most welcome 😊
Excellent ...thanks a lot for u ...from Indonesia
Welcome!
dear Kamal, thank you very much, and much appreciated it.
all the best
Dear Kamal, thank you so much for your helpful video.
Thanksyou so much for help... Really appreciate ur support on call.
Highly appreciated kamal
Many thanks for your kindness
Thank you for such a nice comment Tajammul! This really keeps me motivated to post such tutorials for community.
Thank you sir! You just made my night!
Very clear video and explanation and code, I subscribed 👍
Welcome aboard!😀
it works! thank you.
excellent solution. great coding.
LOVE!!!!!! You made this sooooo simple! Thank you! Thank you!!!
Stay connected !!! :-)
thank you for sharing!! truly amazing.. wish you success sir!
Thanks Kamal. Amazing and time efficient
Thank you Nimesh. Stay connected:-)
Great way of teaching
Hey Thanks Boss, it help's me in my daily routine work. Thanks a a lot !
@Amol. that's awesome.. stay connected..
It's really useful bro thanks🌹🌹🌹.
Thank you very much. Worked like a charm!
Thanks lot sir it really very helpful for me thanks awsome 😊😃
Thank you Manoj.. Please subscribe and share with your friends and help my mission to teach a million students.. :-)
great videos , just a question if i want to rename the file and copy to another path ? the old file list in different sub folder
Legend!
It helped me a lot! Thank you!
Awesome video. its a huge help
Thanks Manoj. Stay connected
Hi Kamal, Thanks for sharing such valuable knowledge, i also updated the code as you taught, but unable to get the folder path in the bar, like as you have shared a template file , Please advise
Can you share your code/files with me so that I can debug?
Great video thank you. Can this also be used to change folder names too?
sure. .I'll post a tutorial on this subject soon.
Thanks will be using your code, just need to modify it so that it can rename files in the subfolder also.
Did you come up with the fix so it could reach the subfolders also?
This is great. THX
Super one !! thank you loads
Glad you liked it! :-)
Suberb man keep it up..Thank u so much
Welcome 👍 Stay connected
That’s a very useful and simple way of doing.
Can this done for the sheet of Excel files in a folder.
Say like there are 60 Excel Files with single sheet in each of them in same folder and I want to rename the sheet of every excel file.
Please make a video for above request
Thanks
Thank you Ifraz. I'll plan for a video on this soon. However if you need this urgently, feel free to write to me at excel.microk@gmail.com
Thanks a lot.
Most welcome!
Thank you for sharing.
Stay connected😃
This macro has a major flaw. If the file is not English characters then the macro will fails. I have to write one additional subroutine to get around that problem.
great. please post your updated code that others can also use.
can u tell me pls which version is applicable of MS office? I use office 2007.here it is n't work.pls help & reply.
I successfully did this before but now when I try to run the first part to fetch the names nothing happens. It just brings up a list of macros and ask me if I want ti run it and when I select run nothing happens. I’m not sure what I’m doing wrong, I did exactly what you did in the video.
Required macro to split the PDF file in to multiple files with different ranges of pages
macro may not be available on this workbook or all macros may be disabled
Right click on get file names. Select macros. Fetch files..edit. and change the location
How if in case there are xls files if we can change the sheet name as well at the same time
Thanks Man!
@Extreme Automation - Kamal Girdher Thanks A lot for such a great video, Its appreciable if u can share Codes for picking Folder path from a specific cell (In my Case "Sheet1"("O5")) in same workbook instead of pre-defined folder path, I tried to get a code for the same from internet, but i cound not make it. Thanks in advance for your support
Hi can you make another version so that it can get all filenames inside a a big foldet which include subfolder? Thanks a lot
can you add some code to include all files in subfolders of the folder chosen to rename please
Sure.
Why is it showing an error - run time error '53': File not found?
Hi, it is very useful. But unfortunately, it copies file extension with it. Is there any way that the file extensions should not be copied.
Yes.. we can do it.. please attach your file (with code )to my email id and I'll send you the updated code..
Hi, we would follow up if the old file is Chinese font and show '?' & how can fix this?
Please can you try file names with space in your program in this video? does this work? example "C:\test\360_00 67.jpg" space included
Hi sir, is that possible to sort it as date modified when you fetch the name? thanks
Thanks bro it worked
Hi Bro, you are fetching details into column A and B. Can we assign the same to some other column like D, E F ?
Veer good video i leran new thing
So nice of you
Hello. I hawe an issue. I receive an error when I try to renamd files that contain ș ț î ă â and. Di you hawe a solution for this?
Thank you very much....
stay connected..
Invaild Qualifier Error for IsEmpty is Coming. How can I Fix it ?
Can we create multiple folders with desired excel document inside all folder in bulk?
Hi Kamal, is there a way to possibly modify the macro, so instead of showing only the files names inside the folder, it will show the name of files in the subfolders as well, so when we click on "Get Files Names' it displays all the files names? Thank you very much :)
Liked it a lot
Nice video, subscribed!
Thanks for the video. The 2nd coding is not working. It’s shows Run-time error ‘5’; . Invalid procedure call or argument. Any thoughts why it’s not working?
I don't know my code is not working. Please help me out
Brother tell us how did you create that 3 bottons please
Sir , please share with some update in code., That is , no need extension name in file name, need only file name.
Hope you understand sir
Thanks,
Hi
Could you do the video including buttons portion also and fetching names code is perfectly working but renaming code is not functioning and saying run time error.....
Can you add a video or include code for extraction of files from zipped folder? Thank you
Thanks a loooooooot....... bro
tq Sir.
Welcome
You are not defining the variable r here, i think it would be a good practice to define all ur variables. Or do you think it is really not necessary to define variable r??
Thank you for this, however I cannot get it to work. I edited the macro so it points to a folder path where my files are stored and thought that would be all I needed to do, however it isn't working.
Please share your file at excel.microk@gmail.com and I'll look into it..
First time I run it didn't work, then I realized that when I copied the folder path from the window and paste it in the VB, it didn't show the last back slash "\". It need to have that last back slash in order to work.
@@djmontoro Thank you this was my issue as well! Works great now
Hi, thank you for the video! I was wondering if it would be possible to use folder picker with this video rather than hard coding the file path. Would appreciate if you have such code.
Yes it is possible as well as recommended way.
@@xtremeExcel Thanks A lot for such a great video, Its appreciable if u can share Codes for picking Folder path from a specific cell in same workbook instead of pre-defined folder path, I tried to get a code for the same from internet, but i cound not make it. Thanks in advance for your support
Moreover, to my previous comment and after using Name statement. I can say it is unstuck, failing or good-for-nothing. Unpredictable errors or fail to rename files (sure they are not opened, not readonly)
Relax Elias. I am sure you must be doing something wrong. Share your code with me.
@@xtremeExcel I am sure,
can you tell me why one of the following lines work where the other not ? I am programmer (~33 years) for many Languages. and mainly Mech Eng. so I can understand you fast. (.JPG & .jpg work both)
Name "D:\Test\660_000010.JPG" As "D:\Test\760_0009.JPG" work
Name "D:\Test\660_000010.JPG" As "D:\Test\660_0009.JPG" doesn't work
This is one of many
Name "D:\Test\660_0008.JPG" As "D:\Test\660_0001.JPG" work
Name "D:\Test\660_0000.JPG" As "D:\Test\660_0001.JPG" doesn't work
thanks you so much
Thank you so much for this!! This is a wonderful tool. I tried and it worked, however it is converting my PDF to file. How do I keep the .pdf? Thank you!
Can you share some more details of your input and outout. :-)
@@xtremeExcel I am trying to change names of multiple PDF files. When I use the template and change the name, it converts it from .pdf to type: file. When I try to open the file it makes me select the output. I am able to then open it in PDF if I select "Open with Adobe". Is there a way to keep it in .pdf type after changing the name? I hope this makes sense.
@@MegaRockstar90210 It worked for me by just adding .pdf to the end of the file name.
THANK YOU
Is there a VBA code that can search multiple folders and rename all of the files in the different folders? In column A I have the filepath down to the pdf that I want renamed and in Colum B I have what I want to change the name to.
This isn't working for me
I get an error
Hi dood, my files corrupting once macro done it's work... Gimme solution plz...
Thanks my boro
Great, thanks. I'm getting debug on Name myPath & Cells(r, 1).Value As myPath & Cells(r, 2).Value
Thanks! Please share you file and screenshot of the error
@@xtremeExcel
This is the error: "Name myPath & Cells(r, 1).Value As myPath & Cells(r, 2).Value ". I don't know how to get the screenshot to send to you.
I use this to rename mp3 files when I rip some of my audiobooks. Windows media player can't find the names so I have to rename them. I was able to reformat the names how I wanted but I couldn't get it to add the .mp3 at the end so I had to add it manually. Am I doing something wrong?
It is hard to understand what exactly you have done and what has happened. Can you record a small video of what steps you have performed so that I can see?
thanks
Audio is not available
Very Good :-)
Hi I am trying to modify my file but unable to keep the format of the image.can you tell me how to keep the same format?
please send me your file. excel.microk@gmail.com