Skip to content

Latest commit

 

History

History
53 lines (40 loc) · 1.38 KB

drives-property.md

File metadata and controls

53 lines (40 loc) · 1.38 KB
Raw
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Drives property (Visual Basic for Applications)
vblr6.chm2182030
vblr6.chm2182030
Office.Drives
23534228-121c-23df-6ea6-c4715f86e312
12/19/2018
medium

Drives property

Returns a Drives collection consisting of all Drive objects available on the local machine.

Syntax

object.Drives

The object is always a FileSystemObject.

Remarks

Removable-media drives need not have media inserted for them to appear in the Drives collection.

You can iterate the members of the Drives collection by using a For Each...Next construct as illustrated in the following code.

Sub ShowDriveList
    Dim fs, d, dc, s, n
    Set fs = CreateObject("Scripting.FileSystemObject")
    Set dc = fs.Drives
    For Each d in dc
        s = s & d.DriveLetter & " - " 
        If d.DriveType = 3 Then
            n = d.ShareName
        Else
            n = d.VolumeName
        End If
        s = s & n & vbCrLf
    Next
    MsgBox s
End Sub

See also

[!includeSupport and feedback]