如何使用excelVBA在指定路径下批量新建指定文件夹

Question

如题所述

Answer 1

Sub GetFolder()
Dim FolderName, FileName, MyFolder, MyFile As String
FolderName = "abc"
FileName = "abc.xls"
MyFolder = Dir("D:\" & FolderName, 16)
MyFile = Dir("D:\" & FolderName & "\" & FileName, 16)
If MyFolder <> "" Then
MsgBox "The folder is OK"
Else
MkDir "D:\" & FolderName
End If
If MyFile <> "" Then
MsgBox "The File is OK"
Else
Open "D:\" & FolderName & "\" & FileName For Output As #1
Close #1
End If
End Sub追问

您好，多谢您提供的代码。麻烦你再帮我看看，我需要用A列中的名称批量新建文件夹存放到B列指定的路径下。

本回答被提问者和网友采纳