Changing folder names from a name based on one column to another

[wleetch]

I am work events where photographers are sorting their pictures into folders based on the Routine number while at the event. But each routine also has a unique ID number that is never repeated that is actually used internally back at the office. So I was wondering if I had an excel sheet that included both of these pieces of information is it possible to write a code that would find all the folders named the after the Routine Number and have it rename it to the ID number?

 

[Rijnsent]

Hi Wleetch,
you can totally do that using VBA. See these posts for inspiration:
https://www.mrexcel.com/forum/excel-questions/1029733-vba-rename-folder-not-file.html
https://www.mrexcel.com/forum/excel...names-folder-files-inside-subfolders-vba.html
Cheers,
Koen