Create a Folder if not exists

    Click On below mentioned image to watch the video:

     

     

     

    Sub CreateTheFolder()
    Dim FSO As Scripting.FileSystemObject
    Set FSO = New Scripting.FileSystemObject

    Dim FDRPath As String
    FDRPath = "C:\abcd\pqr"

    If FSO.FolderExists(FDRPath) = False Then
    FSO.CreateFolder (FDRPath)
    MsgBox "Hi Folder Created"
    Else:
    MsgBox "Folder Already exists in the path"

    End If

    End Sub

    DownLoad The Workbook

     

Hi Everyone,
Welcome to VBA Macros Tutorial. This Tutorial provides comprehensive knowledge on VBA Macros to the user. Hope it enhances your coding skills. If you like this web page kindly Share this to your near and dear. I Prepared this content as per my level of knowledge, if any changes required kindly bring to my notice. Thanks for visiting this web page

Thanks,
Pavan Kumar Gundlapalli