Rename files in bulk using macro | Excel VBA

Показать описание

Renaming files in bulk is easy using vba. In this tutorial, you'll learn how to rename thousands of files (may be of a specific extension) in one go.

There are two sub procedures explained in this example. One fetches names of all files in a folder and the other one helps in renaming them.

Watch this tutorial and do not forget to hit like and subscribe to our channel.

We are looking forward for your comments. :-)

Рекомендации по теме

Комментарии

First macro runs fine. The 2nd didn't work and kept generating a run-time error.

scottnantell

It's just amazing. I spent 3 hrs on some complicated codes. And finally this helped me quickly. Thank you so much.

ve

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. :)

KamarudheenCK

I can't believe someone would share such a valuable tool. I am super grateful for this. You are amazing. Thank you very much!

kathleenmontiel

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.

BlakJak

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!!!

SaSeshen

I cant believe how come you can be so kind to save the world's time!! Thanks so much mate!!!

cheungcassie

You are a saviour❤️ Thank you so So easy to follow and completed task with out any error. 😍

susmithasunil

Very much useful tutorial for novice users. It served my purpose easily. Thank you Kamal.

techiesahamad

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!

martianboy

Thank you so very much! This is a task that I complete monthly. You have reduced the time in accomplishing this task substantially.

Destine

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.

djmontoro