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 : FileExists Method
2. FileSystemObject : DeleteFile Method
3. FileSystemObject in Excel Macro
4. FileSystemObject : CreateTextFile Method
5. VBA-Excel: Add/Insert multiple objects from a folder in an Excel Document.