|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Sub fold()
Dim fso As Object
Dim yy, mm
Application.ScreenUpdating = False
Set fso = CreateObject("Scripting.FileSystemObject")
yy = Year(Date)
mm = Month(Date)
fold1 = "d:\桌面\"
If Dir(fold1, vbDirectory) = "" Then MkDir fold1
fold2 = "d:\桌面\" & yy & "年\"
If Dir(fold2, vbDirectory) = "" Then MkDir fold2
fold3 = "d:\桌面\" & yy & "年\" & mm & "月"
If Dir(fold3, vbDirectory) = "" Then MkDir fold3
Application.ScreenUpdating = True
End Sub
请楼主参考。 |
|