|
Public Sub 获取文件夹中的所有子文件夹名()
'获取文件夹中的所有子文件夹名 (SubFolders)
Dim fso As Scripting.FileSystemObject
Dim myFol As Scripting.Folder
Dim myFolder As String
Dim i As Long, j
myFolder = "C:\Documents and Settings\Administrator\My Documents"
'上面这句指定你的D,E,F三个文件夹及路径
j = UBound(Split(myFolder, "\"))
Range("A1:C1") = Array("序号", "文件夹", "子文件夹名称")
Set fso = New Scripting.FileSystemObject
i = 2
For Each myFol In fso.GetFolder(myFolder).SubFolders
Cells(i, 1) = i - 1
Cells(i, 2) = Split(myFolder, "\")(j)
Cells(i, 3) = myFol.Name
i = i + 1
Next
Set fso = Nothing
End Sub |
|