VBA to Rename Files within sub folders

[Flexi1]

Hi

I am looking for a VBA code to rename file names from column (a) to the new name in column (b) The original files are located in sub folders within a main folder so the VBA code would need to search in sub folders to replace the name.

If anyone can help that would be amazing

 

[Joe4]

So, are the complete file paths in columns A and B?
Can you post a few examples of what your data looks like in these columns?