Drive Property

  • Article

This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.

Description

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