I can't believe someone would share such a valuable tool. I am super grateful for this. You are amazing. Thank you very much!
@xtremeExcel
4 жыл бұрын
Glad it was helpful! Stay connected! :-)
@KamarudheenCK
4 жыл бұрын
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. :)
@xtremeExcel
4 жыл бұрын
Thank you dear. Stay connected😃😃
@BlakJak206
4 жыл бұрын
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.
@ve6571
Жыл бұрын
It's just amazing. I spent 3 hrs on some complicated codes. And finally this helped me quickly. Thank you so much.
@xtremeExcel
Жыл бұрын
Glad it helped!
@susmithasunil6611
3 жыл бұрын
You are a saviour❤️ Thank you so muchhhhhhhh.. So easy to follow and completed task with out any error. 😍
@cheungcassie3047
4 жыл бұрын
I cant believe how come you can be so kind to save the world's time!! Thanks so much mate!!!
@martianboy9886
7 жыл бұрын
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!
@xtremeExcel
7 жыл бұрын
Thank you for the feedback. Keep supporting.. :-)
@SaSeshen
Жыл бұрын
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!!!
@xtremeExcel
Жыл бұрын
Thanks mate !!!
@scottnantell6029
5 жыл бұрын
First macro runs fine. The 2nd didn't work and kept generating a run-time error.
@techiesahamad5979
2 жыл бұрын
Very much useful tutorial for novice users. It served my purpose easily. Thank you Kamal.
@Destine77
5 жыл бұрын
Thank you so very much! This is a task that I complete monthly. You have reduced the time in accomplishing this task substantially.
@xtremeExcel
5 жыл бұрын
Great!
@djmontoro
7 жыл бұрын
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.
@ranajsingh
4 жыл бұрын
absolutely simple and clear piece of code..! great job.! kudos for this knowledge sharing..!
@xtremeExcel
4 жыл бұрын
Thank you for the feedback.. Stay connected! :-)
@aswathkn1719
5 жыл бұрын
This is life savior. Thanks a lot for this tool
@Jeff_Gaudette
3 жыл бұрын
I sub'ed. Great tool & very gracious of you to share the code!
@namanbasantani
4 жыл бұрын
Superb man.. you are too good. Thanks yaar brother..
@xtremeExcel
4 жыл бұрын
Most welcome 😊
@techfununlimited6579
10 ай бұрын
Did what exactly i was looking for... Thanks a lot... Earn a subscriber...
@javierdavila24
3 жыл бұрын
Everything runs very well. Thank you for share with us
@xtremeExcel
3 жыл бұрын
So nice of you
@dandanakan0
4 жыл бұрын
dear Kamal, thank you very much, and much appreciated it. all the best
@MariaOrtiz-t3e
8 ай бұрын
Thanks Kamal!! This will save me a lot of time!!
@laraszepesi5928
2 жыл бұрын
Many thanks, I have been looking for an easy solution. :)
@bayu2861
4 ай бұрын
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
@ahmetoznur88
4 жыл бұрын
Dear Kamal, thank you so much for your helpful video.
@tongirri
4 жыл бұрын
Thank you very much. It saved my time for renaming a lot of files.
@xtremeExcel
4 жыл бұрын
Glad it helped!
@keuanganinsa1006
2 жыл бұрын
Excellent ...thanks a lot for u ...from Indonesia
@xtremeExcel
2 жыл бұрын
Welcome!
@maksim0933
Жыл бұрын
Very clear video and explanation and code, I subscribed 👍
@xtremeExcel
Жыл бұрын
Welcome aboard!😀
@jomercasugay1406
2 жыл бұрын
thank you for sharing!! truly amazing.. wish you success sir!
@nikitakaushal6382
2 жыл бұрын
Thanksyou so much for help... Really appreciate ur support on call.
@SmartcadSoftwareSolutions
5 жыл бұрын
Highly appreciated kamal Many thanks for your kindness
@xtremeExcel
5 жыл бұрын
Thank you for such a nice comment Tajammul! This really keeps me motivated to post such tutorials for community.
@stamatarsenikos9708
3 жыл бұрын
excellent solution. great coding.
@roadlizard2651
2 жыл бұрын
Thank you sir! You just made my night!
@Kiran994.
4 жыл бұрын
It's really useful bro thanks🌹🌹🌹.
@nimeshfaria1242
4 жыл бұрын
Thanks Kamal. Amazing and time efficient
@xtremeExcel
4 жыл бұрын
Thank you Nimesh. Stay connected:-)
@PremSingh-ry7ek
4 жыл бұрын
Great way of teaching
@EliasDaoud
5 жыл бұрын
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
@rochellejennings5280
6 жыл бұрын
Great video thank you. Can this also be used to change folder names too?
@xtremeExcel
6 жыл бұрын
sure. .I'll post a tutorial on this subject soon.
@latoyaj.harris620
6 жыл бұрын
LOVE!!!!!! You made this sooooo simple! Thank you! Thank you!!!
@xtremeExcel
6 жыл бұрын
Stay connected !!! :-)
@chillalamol
5 жыл бұрын
Hey Thanks Boss, it help's me in my daily routine work. Thanks a a lot !
@xtremeExcel
5 жыл бұрын
@Amol. that's awesome.. stay connected..
@ManojSingh-sb2ph
5 жыл бұрын
Thanks lot sir it really very helpful for me thanks awsome 😊😃
@xtremeExcel
5 жыл бұрын
Thank you Manoj.. Please subscribe and share with your friends and help my mission to teach a million students.. :-)
@mxrvxn08
2 жыл бұрын
it works! thank you.
@mohammedkabiri6485
4 жыл бұрын
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 :)
@haroldlopez8900
2 жыл бұрын
Legend! It helped me a lot! Thank you!
@satijamanoj
4 жыл бұрын
Awesome video. its a huge help
@xtremeExcel
4 жыл бұрын
Thanks Manoj. Stay connected
@kathyhoey4745
6 жыл бұрын
Thank you very much. Worked like a charm!
@prashantchauhan449
4 жыл бұрын
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
@xtremeExcel
4 жыл бұрын
Can you share your code/files with me so that I can debug?
@jaikishen100
4 жыл бұрын
Suberb man keep it up..Thank u so much
@xtremeExcel
4 жыл бұрын
Welcome 👍 Stay connected
@deepanatarajan5323
4 жыл бұрын
Super one !! thank you loads
@xtremeExcel
4 жыл бұрын
Glad you liked it! :-)
@Bharani_0601
6 жыл бұрын
Hi Bro, you are fetching details into column A and B. Can we assign the same to some other column like D, E F ?
@medasbabu
3 жыл бұрын
Thanks will be using your code, just need to modify it so that it can rename files in the subfolder also.
@MsTeebree
3 жыл бұрын
Did you come up with the fix so it could reach the subfolders also?
@vuchinavook1770
3 жыл бұрын
This is great. THX
@cookieaddictions
2 жыл бұрын
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.
@murugantgi
3 жыл бұрын
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?
@pawelpala4050
5 жыл бұрын
Thank you for sharing.
@xtremeExcel
5 жыл бұрын
Stay connected😃
@dipakjangam6018
4 жыл бұрын
Veer good video i leran new thing
@xtremeExcel
4 жыл бұрын
So nice of you
@ifrazimanudeen4462
6 жыл бұрын
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
@xtremeExcel
6 жыл бұрын
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
@শেষযমানারকথা
3 жыл бұрын
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.
@felixwijaya868
7 жыл бұрын
Hi sir, is that possible to sort it as date modified when you fetch the name? thanks
@ahrorkuldashev9603
4 жыл бұрын
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
4 жыл бұрын
Yes it is possible as well as recommended way.
@binoyjohn6676
4 жыл бұрын
@@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
@ujjawalso
4 жыл бұрын
Can we create multiple folders with desired excel document inside all folder in bulk?
@dikshantginwal4085
5 жыл бұрын
Thanks bro it worked
@suganthi1418
5 жыл бұрын
Thank you very much....
@xtremeExcel
5 жыл бұрын
stay connected..
@grumpyfan777
4 жыл бұрын
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?
@xtremeExcel
4 жыл бұрын
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?
@torque6389
5 жыл бұрын
Nice video, subscribed!
@moas3060
5 жыл бұрын
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.
@xtremeExcel
5 жыл бұрын
Yes.. we can do it.. please attach your file (with code )to my email id and I'll send you the updated code..
@shadabsirkhot2323
Жыл бұрын
Thanks a lot.
@xtremeExcel
Жыл бұрын
Most welcome!
@vishalkumar-vt3xi
4 жыл бұрын
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??
@MsTeebree
3 жыл бұрын
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.
@EliasDaoud
5 жыл бұрын
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
5 жыл бұрын
Relax Elias. I am sure you must be doing something wrong. Share your code with me.
@EliasDaoud
5 жыл бұрын
@@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
@momowongmh3297
4 жыл бұрын
Hi can you make another version so that it can get all filenames inside a a big foldet which include subfolder? Thanks a lot
@MegaRockstar90210
4 жыл бұрын
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
4 жыл бұрын
Can you share some more details of your input and outout. :-)
@MegaRockstar90210
4 жыл бұрын
@@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.
@janetfrias3687
4 жыл бұрын
@@MegaRockstar90210 It worked for me by just adding .pdf to the end of the file name.
@iivansi3
6 жыл бұрын
man your code rulz. thank you very much sir :)
@binoyjohn6676
4 жыл бұрын
@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
@aniket8931
4 жыл бұрын
Thanks a loooooooot....... bro
@srinuvenkat78
4 жыл бұрын
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.....
@kainaaguiarferreira4351
3 жыл бұрын
Thanks Man!
@nonenone2858
6 жыл бұрын
Hi, it possible to have a word file that was just created take some data(names and values) from inside it and automatically introduce those values in the title of the file? When I close the new document at exit to have the file renamed in my folder automatically by taking the data of choice from inside it?
@syedzafferullah
5 жыл бұрын
Liked it a lot
@vernettep
7 жыл бұрын
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.
@xtremeExcel
7 жыл бұрын
Please share your file at excel.microk@gmail.com and I'll look into it..
@djmontoro
7 жыл бұрын
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.
@jasonkoth4761
6 жыл бұрын
@@djmontoro Thank you this was my issue as well! Works great now
@bsanju585
4 жыл бұрын
Brother tell us how did you create that 3 bottons please
@simplereef4854
Жыл бұрын
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.
@xtremeExcel
Жыл бұрын
great. please post your updated code that others can also use.
@ulhas610
4 жыл бұрын
Hi, Using this simple code still useful in 2020. This works great, but now I'm trying for same name and I get this message: "Run-time error '58': File already exists" Debugging highlights this line "Name myPath & Cells(r, 1).Value As myPath & Cells(r, 2).Value" Any tips? if file name already exists then replace without asking or any msgbox . You help much more appreciate.
@keithmctaggart7663
5 жыл бұрын
can you add some code to include all files in subfolders of the folder chosen to rename please
@xtremeExcel
5 жыл бұрын
Sure.
@SmaraVic
10 ай бұрын
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?
@jacobjacqueline823
6 жыл бұрын
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?
@xtremeExcel
6 жыл бұрын
please send me your file. excel.microk@gmail.com
@sorada2539
4 жыл бұрын
thanks you so much
@ProviderKnowledge
2 жыл бұрын
thanks
@raghavshanbhag9308
7 жыл бұрын
appricate your grat knowladge
@BharatPatel-vb5xc
8 ай бұрын
How if in case there are xls files if we can change the sheet name as well at the same time
@aijadzerox
Жыл бұрын
tq Sir.
@xtremeExcel
Жыл бұрын
Welcome
@EliasDaoud
5 жыл бұрын
After revising my code and samples. I am sure 100% the "Name" statement is for kids. and this issue is closed / terminated for me. and I bet Microsoft themselves about this issue. The Name statement cannot rename an old file with space or such (and I don't know why) 360_0000 to become 360_0001 but it can be to 460_0001 or 370_0001 or any but not starting with 360. this mean it has problem with space " " and "_" in a way or zeros. such 360_0002 can be renamed to 360_0001 or any other
@stephenlefranc3805
4 жыл бұрын
Does this work for Mac I can't get the file names thing to open...
@upgradetechnicalskills3392
5 жыл бұрын
Hi sir very helpful tips Can be used the same code for PDF files
@xtremeExcel
5 жыл бұрын
yes. it can be used for any file extension..
@upgradetechnicalskills3392
5 жыл бұрын
Hi I have tried to PDF files it's not working. See I have more than thousands PDF files I want to rename at a time with the help of Excel VBA codding is it possible.
@xtremeExcel
5 жыл бұрын
Please send your code to me.
@upgradetechnicalskills3392
5 жыл бұрын
Now it's working fine sir Due to some issue that is from my end. Thanks again for the most useful training.
@xtremeExcel
5 жыл бұрын
Great!
@mathconcept8635
3 жыл бұрын
Hi, we would follow up if the old file is Chinese font and show '?' & how can fix this?
@beehroidahmadi4352
2 жыл бұрын
Thanks my boro
@822sanjeev
6 жыл бұрын
Required macro to split the PDF file in to multiple files with different ranges of pages
@fairyzhang8513
4 жыл бұрын
Hello, your Excel VBA renamed all my document name at once, but the document version is not a PDF file anymore, could you please help me further, many thanks.
@xtremeExcel
4 жыл бұрын
Did you put extension in the output file names?
@debjani_d
5 ай бұрын
Why is it showing an error - run time error '53': File not found?
@aristotleashok8990
4 жыл бұрын
Hi dood, my files corrupting once macro done it's work... Gimme solution plz...
@suganthi1418
5 жыл бұрын
Can you add a video or include code for extraction of files from zipped folder? Thank you
@jugal8591
3 жыл бұрын
Invaild Qualifier Error for IsEmpty is Coming. How can I Fix it ?
Пікірлер: 191