If your looking for the drive letter, why not use the following method:
Dim fs As scripting.FileSystemObject
Dim Drive As scripting.Drive
Dim drivecollection As scripting.Drives
Dim intDrive As Integer 'drivenumber
On Error GoTo ErrorOpen
Set fs = CreateObject("Scripting.FileSystemObject"

Set drivecollection = fs.Drives
intDrive = 0
For Each Drive In drivecollection
'pass drive letters to an array of buttons
cmdDrive(intDrive).Caption = Drive.DriveLetter & ":"
cmdDrive(intDrive).Visible = True
intDrive = intDrive + 1
Next
Exit Sub
ErrorOpen:
If Err.Number = 68 Then 'no disc in drive
Else
If Err.Number = 71 Then 'drive not ready
Else
strBericht = "Failure " & CStr(Err.Number) & " :" & vbCr & _
Err.Description
MsgBox strBericht, vbExclamation, "Alert!"
End If
End If
you can determine the drive type the following way:
Set Drive = fs.GetDrive(strDrive) 'strDrive contains a directory path
Select Case Drive.DriveType
Case 0: strDriveType = "Unknown"
Case 1: strDriveType = "Removable"
Case 2: strDriveType = "Fixed"
Case 3: strDriveType = "Network"
Case 4: strDriveType = "CD-ROM"
Case 5: strDriveType = "RAM Disk"
End Select
you can determine the name of the drive the following way:
If Drive.DriveType = 3 Then
strDriveName = Drive.ShareName
Else
strDriveName = Drive.VolumeName
End If
Hope this helps.