Private Declare Function GetDriveType Lib "kernel32" Alias "GetDriveTypeA" (ByVal nDrive As String) As Long
Const DRIVE_CDROM = 5
Private Sub Command1_Click()
Dim i As Integer, mydrive As String
For i = 0 To 25
mydrive = Chr(i + 65) & ":\"
If GetDriveType(mydrive) = DRIVE_CDROM Then Debug.Print mydrive & " is cd-rom"
Next
End Sub