Finding the Zip Drive in a world of floppies and CD-Roms and Chickens

[thedoc1]

Okay,

Here is the scoop.

I am working on a program makes a backup on a zip drive. I want to just specify the zip drive in the combo box.

Here is information from Microsoft.

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

If I set the drive type to only allow type 2 - it would include the floppy and the zip drive.

How can I specify just the zip drive?

Thanks for your help

Doc