How can I tell if the CD-ROM drive is opened or closed trough code? I know how to open and close it, but I would like to know if it is opened or closed at a given moment.

For example:

If "D:\" = "Open" Then
MsgBox "D is open"
Else
MsgBox "D is closed"
End If

(I wish that would work!)

(I also know how to get the CD-ROM drive letter, so it can be hard-coded in an example.)

Thanks,

Allen