Sub TEST()
On Error Resume Next
For I = 2 To Range("A65536").End(3).Row
D = Split(Cells(I, 1), "\")
MkDir D(0) & "\" & D(1)
MkDir D(0) & "\" & D(1) & "\" & D(2)
Next
End Sub
看看这样是不是你要的:
Sub ege()
Dim arr
Dim x As Integer
arr = Sheets(1).Range("a2:a" & Range("a65536").End(xlUp).Row)
MkDir "c:\test"
MkDir "d:\test"
MkDir "e:\test"
MkDir "f:\test"
For x = 1 To UBound(arr)
MkDir arr(x, 1)
Next
End Sub