How to rename file in Windows 10 using VBA | How to rename file in Windows 11 using VBA
1- Open Excel and Create a new Project
2- Go to Developer Tab
3- Click on Insert in Developer Tab
4- In ActiveX Controls, Pick a button and create a button
5- Double Click on the Button and Paste the Code
Private Sub CommandButton1_Click()
Dim i, j As Integer
i = 2 ' Start Row
j = 118 ' End Row
For i = 2 To j
Name ActiveSheet.Cells(i, 1).Text As ActiveSheet.Cells(i, 2).Text
Next i
End Sub
6- Type Old Path and New Path as below given
7- Row A – Old Path and Row B – New Path
