FileSystemObject : FolderExists Method

Description: 

Returns True if a specified folder exists; False if it does not.

Format : 

objectOfFileSystemObject. FolderExists(foldername)

Arguments: 

• objectOfFileSystemObject
  • As the names says, it’s a FileSystemObject.
• foldername
  • Mandatory
  • Type:     String
  • Folder , whose existence to be determined.

Function FnIsFolderExist(strCompleteFolderPath)
      Set fso = CreateObject("Scripting.FileSystemObject")
      If fso. FolderExists(strCompleteFolderPath)Then
                    strStatus = strCompleteFolderPath & “  folder exists”
            Else
                    strStatus = strCompleteFolderPath & “  folder does not exist”
           End If
        FnIsFolderExist = strStatus
End Function 

Msgbox FnIsFolderExist ("c:\New Folder")

Also Read:

1. VBA-Excel: Add/Insert multiple objects from a folder in an Excel Document.
2. FileSystemObject : GetDriveName Method
3. FileSystemObject:OpenTextFile Method
4. FileSystemObject : GetFileVersion Method
5. FileSystemObject : CreateTextFile Method