FileSystemObject : DriveExists Method

Description: 

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

Format : 

objectOfFileSystemObject. DriveExists(DriveName)

• objectOfFileSystemObject : As the names says, it’s a FileSystemObject.

Arguments: 

• fileName
  • Mandatory
  • Type:     String
  • Drive name , whose existence to be determined.

Function FnIsDriveExist(strDriveName)
      Set fso = CreateObject("Scripting.FileSystemObject")
      If fso. DriveExists(strDriveName)Then
                    strStatus = strDriveName & “  drive exists”
            Else
                    strStatus = strDriveName & “  drive does not exist”
           End If
        FnIsDriveExist = strStatus
End Function

Msgbox FnIsDriveExist ("c")

Also Read:

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