VBA- Rename files based on cell value

[sanket_sk]

Hi There,

Hope you all are doing good,

I need your help here.

I have multiple files in folders as well as in subfolders, list of these files is available in excel column A, I want to rename these files with cell values in column B.

I am looking for VBA/Macro who will go through folders/ subfolders, check the file name and rename these files with column B value.

Note:- These files can be excel, Word, or with any extension- we do not have any restrictions here.

Folder Path: C:\Users\Documents\Projects\

Sample files

Sample data

Book1
	A	B
1	Origional File name in folder	Name to be changed with
2	Mumbai	Maharashtra _Mumbai
3	Delhi	Delhi _Delhi
4	Bangalore	Karnataka _Bangalore
5	Hyderabad	Telangana _Hyderabad
6	Ahmedabad	Gujarat _Ahmedabad
7	Chennai	Tamil Nadu _Chennai
8	Kolkata	West Bengal _Kolkata
9	Surat	Gujarat _Surat
10	Pune	Maharashtra _Pune
Sheet1

 

[davesexcel]

Here is the special missing line.

name oldName as newName

See this thread.
Rename files in folder

Practice this simple version of renaming the files and once you have that going smoothly, ask again on how to change the file names in subfolders
as that would be more involved answer.

 

[Jimmypop]

I think this is what you are looking for... great tutorial...