Function FindCDROMDrive
' Returns an array of CD ROM drives
Dim fso : Set fso = CreateObject("Scripting.FileSystemObject")
Dim d, dc, aResult
ReDim aResult(-1)
Set dc = fso.Drives
For Each d in dc
If d.DriveType = 4 Then
ReDim
Preserve aResult(UBound(aResult)+1)
aResult(UBound(aResult)) = d
End if
Next
FindCDROMDrive = aResult
End Function