Тёмный

How to Rename 1000s of Multiple files in one Second | VBA Macro in Excel 

Buzz2day Tech
Подписаться 352 тыс.
Просмотров 20 тыс.
50% 1

How to Rename 1000s of Multiple files in one Second | VBA Macro in Excel
#VBAExcel #MacroExcel #RenameMultipleFiles
✦✦✦✦✦✦✦ Join TeleGram ✦✦✦✦✦✦✦
✦✦✦ t.me/buzz2daytech ✦✦✦
Description:
#Buzz2Day Tech
►► Join Facebook Group for your Queries:
/ b2dtech
Social Media:
Telegram ► t.me/buzz2daytech
Subscribe ► goo.gl/YWVPKH
Facebook ► goo.gl/P4pq8q
Twitter ► goo.gl/vl7Nj5
Instagram ► / buzz2daytech

Опубликовано:

 

27 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 96   
@sachinkumarjain3346
@sachinkumarjain3346 3 года назад
Nice session sir 👍👍 Pranam guru ji 🙏🙏
@saurabhgurav8935
@saurabhgurav8935 Год назад
Bhai apane mera kam aasan bana diya Thank you so much 😊😊
@bablughosh9410
@bablughosh9410 2 года назад
Thank you so much brother, You have made my life easier 👍👍👍
@akifahmed-g1s
@akifahmed-g1s 11 месяцев назад
thank you so much for wonderful amazing magical solution for renaming.
@trizzlingtech02
@trizzlingtech02 3 года назад
Nice information sir !! Really awesome trick 🤩🤩
@skk-ks6re
@skk-ks6re 3 года назад
Hlo Sir ho saka to aap search engine banana sikhaya Thanks
@Harry-uc2ph
@Harry-uc2ph 11 месяцев назад
बहुत अच्छा लगा जिस तरह से आपने समझाया। धन्यवाद! मुझे एक समस्या आ रही है, मुझे कुछ हिंदी ऑडियो फ़ाइल का नाम में बदलाव करना है लेकिन वह नहीं हो रहा है उसकी जगह पर ???? आ रहा है। कृपया इसे हल करने में सहायता कीजिए🙏🏻
@CodeMonsterOfficial
@CodeMonsterOfficial 3 года назад
Sir Jab open file button pe click kare tab automatically chose folder vala menu open ho jaay How to do this? please tell me.
@Mrdmkumar
@Mrdmkumar 3 года назад
Jee sir yes✅✅✅ yesa ho jaaye to kamal ho jayega
@Buzz2dayTech
@Buzz2dayTech 3 года назад
kar denge esa bhi ek naya project with naye function k sath bana denge!
@CodeMonsterOfficial
@CodeMonsterOfficial 3 года назад
Thank you sir
@harshappy8914
@harshappy8914 2 года назад
Bro you are a life saver Subscribed👍
@Sk_Sajjan
@Sk_Sajjan 4 месяца назад
Hello Sir, Is code me only .jpg extension lena hai or usi me export Krna but Excel me .jpg likhna n pre uske liye kya Krna hoga
@krishna_bhushan
@krishna_bhushan 3 года назад
GuruJi, kya aap TeamTalk 5 windows software ke baare mein Puri tarah se bata sakte hain?
@techgrow2.0
@techgrow2.0 Год назад
Thanks bro we have a talented person
@atrangiicustomprintinganda8093
such a great option to save time, thanks bro.
@manmohansharma2968
@manmohansharma2968 3 года назад
Thank you so much bhaiya 🙏🙏
@keshav9332
@keshav9332 3 года назад
sir aapne ek video banaya hua hai screen recorder making using visual studio 2019 sir usme apne ffmpeg ka use kiya aur se download kiya to apne ffmpeg.org ki website ko open kiya to waha pe apne zerenoi se ffmpeg download kiya lekin mere waha windows me .gyan Dev aur btbn show ho rha hai sir maine kai youtube channel me dekhe likin jo bhi link hai wo unlogo ka old link hai lekin sir app mujhe new link do please sir. sir world best channel is buzz2daytech and your videos is very very very very very very great and helpful please reply me sir sir please answer my question
@Buzz2dayTech
@Buzz2dayTech 3 года назад
Description m check kro ek br shayad maine file upload kr rkhi h
@keshav9332
@keshav9332 3 года назад
@@Buzz2dayTech no sir aap mujhe new link dijiye discription me nhi hai sir please give me reply pleaseeeeeee
@Buzz2dayTech
@Buzz2dayTech 3 года назад
M eveNing tk deta hoon free hokar
@keshav9332
@keshav9332 3 года назад
@@Buzz2dayTech sir please de dijiyega but sir wo dekhkar dijiyega jisme this sit can't reached na likhe
@Buzz2dayTech
@Buzz2dayTech 3 года назад
M khud apna link de dunga don't worry
@shivanandbhagwat2495
@shivanandbhagwat2495 3 года назад
Thank you so much for this tutorial. Can system keep the extension same as original file name without giving extension to the renamed file.
@RahulSharma-st4mn
@RahulSharma-st4mn 3 года назад
trick is best
@SK2k251
@SK2k251 7 месяцев назад
Here is Script: Sub FetchFileNames() Dim myPath As String Dim myFile As String myPath = "E:\backup\02" myFile = Dir(myPath & "*.*") r = 2 Do While myFile "" Cells(r, 1).Value = myFile r = r + 1 myFile = Dir Loop End Sub Sub RenameFiles() Dim myPath As String myPath = "E:\backup\02" r = 2 Do Until IsEmpty(Cells(r, 1)) And IsEmpty(Cells(r, 2)) Name myPath & Cells(r, 1).Value As myPath & Cells(r, 2).Value r = r + 1 Loop MsgBox ("File Name has been renamed") End Sub
@sobiacips821
@sobiacips821 11 месяцев назад
sir i have some confusion kindly tell me where i contact
@computerknowledge8456
@computerknowledge8456 Год назад
COPY karne ke liye kya command hai Jaise folder me 4 file hai jinka name A1,B1,C1,Aur D1 hai in sab ka 4 copy karna hoga to kaise karenge jaise ki A1 ka copy hoke A2 A3 A4 A5 ho jaye same folder me Usi trah se B1 ka B2 B3 B4 B5
@nagasaitirunagari4603
@nagasaitirunagari4603 Год назад
Thank you so much anna
@Mrdmkumar
@Mrdmkumar 3 года назад
Thanks for your support💪💪💪💪💪💪
@souvikraharoy5650
@souvikraharoy5650 3 года назад
i am using WPS Spreedsheet but i am not getting visual basic option and other option in developer tab
@sudhansusekharbarik6401
@sudhansusekharbarik6401 3 года назад
Wow sir
@sachinkumarjain3346
@sachinkumarjain3346 3 года назад
Channel ko subscribe karo Video ko like karo share karo yaar Aaapne nikhil sir ka channel ha Bhaut hard work karna padta ha ek video banane ke liye jo aapne sir kar hi rahe ha 👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍👍
@manmohansharma2968
@manmohansharma2968 3 года назад
Bhaiya jitne b youtuber hai wo sbi bht mhnt krte h. Har ek vdo ko bnane m... plz support all
@manmohansharma2968
@manmohansharma2968 3 года назад
Ha but ek baat hai nikhil bhaiya is best youtuber qki bhaiya har ek ki baat sunte hai or rply krte hai jo inhe ek best youtuber bnati hai... nikhil bhaiya thank you 👍
@sachinkumarjain3346
@sachinkumarjain3346 3 года назад
@@manmohansharma2968 ​Yes you are right all RU-vidrs are hardworking that is why I support all RU-vidrs.
@keshav9332
@keshav9332 3 года назад
Sir aapne dictionary with database banaya hua hai usme aapne visual studio me toolbox ke noche data usage hota hai data usage mujhe sayad galti se unpin ho gya hai esliyen wo waha pe so nhi ho rha hai sir please solution bataye sir pleaseeeeeeeeeeeeeeee
@sandeepjaiswal9292
@sandeepjaiswal9292 2 года назад
hello , actually mere file name jo rename ho rahe hain us main kkuch duplicated bhi hai tho uske liye kya code use karo
@9631858530
@9631858530 2 года назад
AS you show but it is not Rename the file in folder it give run time error 58 please provide the solution
@newfact7232
@newfact7232 3 года назад
Sir apa video Kaise banate hai usake bare me bataeye
@yalmanhashmi3563
@yalmanhashmi3563 4 месяца назад
Please share the script , i am facing "Run time" error.
@electroheight
@electroheight 2 года назад
we have lots of excel file ...then how to convert the excel file name with the specific cell value.... every file have diffrent cell value
@innerpeacefindings1046
@innerpeacefindings1046 2 года назад
kindly given excel file
@goldenwords5266
@goldenwords5266 2 года назад
It dint work for me Can i get help
@rahulpathak4588
@rahulpathak4588 Год назад
Could you please share that excel file with me
@famousworld5616
@famousworld5616 2 года назад
yeh file kis series me upload leta hai woh bata dijiye kyuki hamari file name change ho rahi par unka series nahi aa raha... jaisa mujhe ek ke baad ek file name chahiye waisa nahi aa raha ..
@famousworld5616
@famousworld5616 2 года назад
kyuki yeh name upload ek ke baad ek nahi kar raha
@ITTCKanjur
@ITTCKanjur Год назад
438 error showing how to resolved
@Artist77osi
@Artist77osi 2 года назад
could you please share the code ?
@pratyushkumar943
@pratyushkumar943 3 года назад
sir how to use these in word
@harshitkushwah5897
@harshitkushwah5897 3 года назад
First like
@rohanjha8780
@rohanjha8780 3 года назад
Run time error '53':
@relaxgym6415
@relaxgym6415 Год назад
i have also same issue but solved i have same files names in my folder
@raghu0689
@raghu0689 Год назад
Can you please send the codes
@trizzlingtech02
@trizzlingtech02 3 года назад
Sir please please instagram par reply dijiye 🙏🙏
@puneetsharma1855
@puneetsharma1855 2 года назад
mua makaluda
@adityacomputersdooni5849
@adityacomputersdooni5849 3 года назад
sirf ext change karna ho to
@Buzz2dayTech
@Buzz2dayTech 3 года назад
Extension b change ho jaega . K baad jo extension chahte ho wo likhdo
@adityacomputersdooni5849
@adityacomputersdooni5849 3 года назад
@@Buzz2dayTech thanks sir
@tusharsrivastava9764
@tusharsrivastava9764 Год назад
Script required my showing error 53
@relaxgym6415
@relaxgym6415 Год назад
me tooo
@relaxgym6415
@relaxgym6415 Год назад
me too but solved i have same files names in my folder i changed the names
@bangaloretravel1092
@bangaloretravel1092 2 года назад
Pls send me file
@vinujangid2930
@vinujangid2930 3 года назад
Sir information good h ❤️ Aap kisi din free hokar complete VB Script samjhaiye na
@umesh5237
@umesh5237 10 месяцев назад
Run karne pe time error '53' path/file access error show ho raha hai solution batao please
@akifahmed-g1s
@akifahmed-g1s 11 месяцев назад
could you rectify this error please? ambiguous name detected: fetchfilenames ?
@BRIJESHKUMAR-ju2mv
@BRIJESHKUMAR-ju2mv 11 месяцев назад
Bro run ke baad run time error 75 AA Raha hai
@superlist154
@superlist154 3 года назад
Very nice bhai, bhut Acha laga, bhai ek help kro captcha ko vba se todna hi
@trizzlingtech02
@trizzlingtech02 3 года назад
Sir please please instagram par reply dijiye 🙏🙏
@yashdeep9757
@yashdeep9757 3 года назад
Superb
@bahubalipatil405
@bahubalipatil405 3 года назад
Please send excel file link
@Buzz2dayTech
@Buzz2dayTech 3 года назад
Will provide the excel file in 2 hours
@7513747
@7513747 3 года назад
This is really amazing. Could you pls provide macro script already written in notepad or anything. That will be very helpful. You are doing a great job. Also is it possible to send me your number so I can speak to you. Thanks
@pcpaliwal01
@pcpaliwal01 7 месяцев назад
Best
@UmairMalik009
@UmairMalik009 3 года назад
very nice video Bro. but at the end i face Error 53, kindly help me out
@broken14300
@broken14300 3 года назад
Sir script run karraha hu to excel pe original file ka naam hi nahi araha hai
@anuragsharma2668
@anuragsharma2668 Год назад
Thanku very much sir ❤
@nagasaitirunagari4603
@nagasaitirunagari4603 Год назад
Thank you so much anna
@muhammadafzal237
@muhammadafzal237 3 года назад
Bhai sahab isma tu utna hi kam kerna pad raha ha jitna normal name change krny ma hota ha, phir itny coding ka kya faida! Har ak file k liye alag se name lekna pad raha ha aur extension alag se..
@Buzz2dayTech
@Buzz2dayTech 3 года назад
Jab ap puri ek range select krke name replace krte ho.. tb time ka pta chalta h..
@muhammadafzal237
@muhammadafzal237 3 года назад
@@Buzz2dayTech Range select krna mujy nai ata per 0:14 k bad kuch seconds ko mention krna chahta taa.
@muhammadafzal237
@muhammadafzal237 3 года назад
@@Buzz2dayTech Sorry yaar wo dosra wala comment ma kisi aur ko kr raha tha, pata nai kasy apko send hogya..!!
@rohanjha8780
@rohanjha8780 3 года назад
Sir solve
@presentgyan4143
@presentgyan4143 3 года назад
👍👍
Далее
Rename Multiple Files in Windows at Once using Excel
7:57
VBA to BROWSE & COPY Data from SELECTED File in Excel
10:00
OpenAI’s New ChatGPT: 7 Incredible Capabilities!
6:27
How To Bulk Rename Files in Windows
1:35
Просмотров 7 тыс.