|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
本帖最后由 逍遥爱迪生 于 2024-5-29 11:56 编辑
Function CreateFolder(ByVal szCheckFolder As String) As Boolean
Dim szFolderBuff() As String
Dim nFolderLayer As Long
Dim szFolderNow As String
Dim i As Long
Dim szFolder As String
szFolderNow = ""
Dim Lefts As String, ID As Long
If Dir(szCheckFolder, vbDirectory) <> "" Then
CreateFolder = True
Exit Function
End If
ID = InStr(3, szCheckFolder, "\")
If ID > 0 Then
Lefts = Left(szCheckFolder, ID - 1)
szCheckFolder = Mid(szCheckFolder, ID)
End If
'lefts=
szFolderBuff = Split(szCheckFolder, "\")
nFolderLayer = UBound(szFolderBuff)
On Error Resume Next
If nFolderLayer < 1 Then
CreateFolder = False
Else
szFolderNow = szFolderBuff(0)
szFolderNow = Lefts & szFolderNow
For i = 1 To UBound(szFolderBuff)
Err.Clear
szFolderNow = szFolderNow & "\" & szFolderBuff(i)
szFolder = Dir(szFolderNow & "\", vbDirectory)
If 0 = Len(szFolder) Then
MkDir szFolderNow
'CreateDirectory(szFolderNow
End If
Next i
End If
CreateFolder = Err.Number = 0
End Function
|
|