Skip to content

Latest commit

 

History

History
46 lines (34 loc) · 1.2 KB

drive-property.md

File metadata and controls

46 lines (34 loc) · 1.2 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Drive property (Visual Basic for Applications)
vblr6.chm2181976
vblr6.chm2181976
Office.Drive
34512359-067f-f625-5f19-db7b0faa0138
12/19/2018
medium

Drive property

Returns the drive letter of the drive on which the specified file or folder resides. Read-only.

Syntax

object.Drive

The object is always a File or Folder object.

Remarks

The following code illustrates the use of the Drive property.

Sub ShowFileAccessInfo(filespec)
    Dim fs, f, s
    Set fs = CreateObject("Scripting.FileSystemObject")
    Set f = fs.GetFile(filespec)
    s = f.Name & " on Drive " & UCase(f.Drive) & vbCrLf
    s = s & "Created: " & f.DateCreated & vbCrLf
    s = s & "Last Accessed: " & f.DateLastAccessed & vbCrLf
    s = s & "Last Modified: " & f.DateLastModified  
    MsgBox s, 0, "File Access Info"
End Sub

See also

[!includeSupport and feedback]