엑셀

엑셀 vba Create_Folder

아스C# 2018. 11. 28. 01:00
반응형

Function Create_Folder(str As String, Optional autoDate As Boolean = False)

    

    If autoDate = True Then

      Path = str & Format(Now, "-yyyymmdd-hhmmss")

    Else

      Path = str

    End If

    

    filePath = Path

    If Dir(filePath, vbDirectory) = "" Then

        MkDir (filePath)

    End If

    Create_Folder = filePath

End Function


..










.




반응형