Hi Lora, Here is the vba code to rename all folders in root folder form existing name to new name. ...
Hello, Please see the below macro, it will clear the data in the B if they have more rows...
Hello Lora,Please check below procedures, I hope one of this will help to solve your query.You can get the Active...
You're welcome..You can delete this lineThen format it as you wishor replace the previous line with the proper format
You are awesome, it works perfectly. Only issue is that the Date format in the Output Sheet is coming in...
Hello Try this code [code] Sub Test() Dim a As Variant Dim b As Variant Dim i As Long Dim...
It is not totally clear for me ..
HI Yasser, Thanks for your code. But, code represents total number of slides in a presentation. I want to get...
I want help to rename all folders in a root folder with different name using VBA. So that one button click it should happen. In Excel I have all existing folder names in one column and new folder names in another column. Appreciate your help here.
Here is the vba code to rename all folders in root folder form existing name to new name. The below code will loop through all folder names and will update new name.
Const sRootFolder As String = "C:\Users\IBM_ADMIN\Desktop\3QWk10\SubBrand Integration\"
Dim Old_FolderName As String, New_FolderName As String
For i = 2 To .Range("AE1").End(xlDown).Row
Old_FolderName = sRootFolder & Sheets("Settings").Range("AE" & i)
New_FolderName = sRootFolder & Sheets("Settings").Range("AF" & i)
Name Old_FolderName As New_FolderName
Hope it resolves your requirement
Please share using the share button above.
If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.
Found the answer useful and wants to credit the user, then vote the answer (vote up).
Enter the destination URL
Or link to existing content