1 2 3 4 5 6 7 8 9 10 11 12 13 14
| Sub Perm_Mat_Name()
Dim OldFolderName, NewFolderName As String
Dim objFSO As Object, mysource As Object, Folder As Object
Dim newName As String, newNameSplit As String, splitMatrNom() As String
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set mysource = objFSO.GetFolder("D:\Test\Pers")
For Each Folder In mysource.SubFolders
splitMatrNom = Split(Folder.Name, " - ")
newNameSplit = splitMatrNom(1) & " - " & splitMatrNom(0)
Debug.Print newNameSplit
If Folder.Name <> newName Then Folder.Name = newNameSplit
Next Folder
End Sub |
Partager