File System - DriveType

Syntax:
=DriveType(Index)

Description:
Returns the type of drive of the drive specified.

Index : Number or letter that identifies a drive.

Return values:
FIXED, REMOVABLE, CDROM, RAMDISK, REMOTE, UNKNOWN

Example:

Determine the drive type of the first drive. =DriveType(1)