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