I am using a VBA to create folders from usernames in excel
however I need to also add permissions so only the user whos name matches the folder has full access no one else but admins

I used http://superuser.com/questions/79966...th-a-vba-macro to make the vba

VBA code:
Sub CreateFolderStructure()    
    For Each objRow In UsedRange.Rows
        strFolders = "C:\myRootFolder"            
        For Each objCell In objRow.Cells
            strFolders = strFolders & "\" & objCell
        Next            
        Shell ("cmd /c md " & Chr(34) & strFolders & Chr(34))
    Next    
End Sub
worksheet is set up like: just for testing... end product will have all the users
User1 Folder1 Subfolder1
User2 Folder2 Subfolder2
User3 Folder3 Subfolder3


this makes the folders just fine

Does anyone know of a way to add a permissions command or something so I don't have to manually change over 100 permissions.