Where is my CD drive 1

[JesOakley]

Hi,

Does anyone know of a way (using vba) to tell which drive letter equates to the CD drive? My back-end db is running off CD, but some users have C drives partitioned into C and D drives.

 

[Remou]

Have a look at DriveType for the FileSystemObject Drive Object.

Sub ShowDriveType(drvpath)
    Dim fs, d, s, t
    Set fs = CreateObject("Scripting.FileSystemObject")
    Set d = fs.GetDrive(drvpath)
    Select Case d.DriveType
        Case 0: t = "Unknown"
        Case 1: t = "Removable"
        Case 2: t = "Fixed"
        Case 3: t = "Network"
        Case 4: t = "CD-ROM"
        Case 5: t = "RAM Disk"
    End Select
    s = "Drive " & d.DriveLetter & ": - " & t
    MsgBox s
End Sub

 

[JesOakley]

Exactly what I was looking for! Thanks very much.