Public Declare Function MakeSureDirectoryPathExists Lib "imagehlp.dll" (ByVal DirPath As String) As Long
Public Sub PathCrt() 'creat a path with path naming in the string
Dim pathnew As String
pathnew = Application.InputBox("the new create path")
MakeSureDirectoryPathExists pathnew
End Sub
这个脚本可以根据你输入的路径和文件夹名来建立文件夹,你自己改改加个循环嵌套,在excel里列出来你要键的文件夹,然后调用上面的命令一个个生成文件夹就好了
温馨提示:内容为网友见解,仅供参考