vba create directory

The solution for “vba create directory” can be found here. The following code will assist you in solving the problem.

‘requires reference to Microsoft Scripting Runtime
Function MkDir(ByVal strDir As String, ByVal strPath As String)
Dim fso As New FileSystemObject
Dim path As String
path = strPath & strDir
If Not fso.FolderExists(path) Then
fso.CreateFolder path
End If
End Function

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts