Dim folderStr As String
folderStr = "C:\aa\bb\cc\dd\ee"
buildfolder (folderStr)
End Sub
Private Sub buildfolder(ByVal FolderPath As String) '用FSO建立多重文件夹
On Error Resume Next
Dim FSO As New FileSystemObject
Dim folderStr As String
Dim mFolder As Folder
folderStr = FolderPath
Dim i As Long
Dim foldername As String
If Right(folderStr, 1) = "\" Then
folderStr = Left(folderStr, Len(folderStr) - 1)
MsgBox folderStr
End If
Dim patharr As Variant
patharr = Split(folderStr, "\")
foldername = patharr(0)
For i = 1 To UBound(patharr)
foldername = foldername + "\" + patharr(i)
Set mFolder = FSO.CreateFolder(foldername)
Next
Set mFolder = Nothing
Set FSO = Nothing
End Sub