Hi All,

I'm working on a code to rename 1000s of folders and I'm afraid that I've hit a dead end. I'm not entirely sure how to proceed. I have an excel document set up like this:

Column B: Original File Source
Column C: New File Source

How do I code somethng that renames every folder in a parent folder? Any help would be much appreciated. My code is below: 

Sub FolderRename()
    'Declaring variables
Dim complete_pathof_folder As String, state As String
For i = 2 To Sheets("Sheet1").Range("B2").End(x1Down).Row
  
  'Variable values
        filesource = Cells(i, 2)
        newfilesource = Cells(i, 6)
       
'Renames Original Folder Name
Name completepathof As newfolderpath
Next i
End Sub