Option Explicit

Private Declare Function GetDriveType Lib "kernel32" Alias _
        "GetDriveTypeA" (ByVal nDrive As String) As Long

Private Const DRIVE_CDROM = 5

Private Sub Form_Load()
  GetCDROMDrive
End Sub

Private Sub BI_GetCDROMDrive()
  Dim intI As Integer
  Dim tmpDrive As String

  On Error GoTo ErrorHandler

  For intI = 0 To 25
    tmpDrive = Chr(65 + intI) & ":\"

    If GetDriveType(tmpDrive) = DRIVE_CDROM Then
      List1.AddItem tmpDrive
    End If
  Next

  If List1.ListCount = 0 Then
     List1.AddItem "Kein CD-ROM vorhanden"
  End If

  Exit Sub

ErrorHandler:
  MsgBox "Es ist Fehler " & Err.Number & " - " & Err.Description _
     & " aufgetreten."
  Exit Sub
End Sub