第2个回答 2016-10-12
Sub text()
Dim i, j, k
For i = 1 To Sheet6.Range("a65536").End(3).Row
MkDir ("d:/" & Sheet6.Range("a" & i))
Next
End Sub
Sub 提取文件夹名称()
Dim fs As Object, f As Object, fd As Object, n
n = 1
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.getfolder("d:\")
For Each fd In f.subfolders
Sheet6.Cells(n, 1) = fd.Name
n = n + 1
Next
Set f = Nothing
Set fs = Nothing
End Sub