Question : vba create directory
Answered by : vastemonde
'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 FunctionSource : https://stackoverflow.com/questions/43658276/create-folder-path-if-does-not-exist-saving-issue | Last Update : Fri, 28 May 21