Edit

Path property

  • Article

Returns the path for a specified file, folder, or drive.

Syntax

object.Path

The object is always a File, Folder, or Drive object.

Remarks

For drive letters, the root drive is not included. For example, the path for the C drive is C:, not C:\.

For files, the Path property includes the filename and extension.

The following code illustrates the use of the Path property with a File object.

Sub ShowFileAccessInfo(filespec)
    Dim fs, d, f, s
    Set fs = CreateObject("Scripting.FileSystemObject")
    Set f = fs.GetFile(filespec)
    s = UCase(f.Path) & 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

This will return a Message Box with content in the format:

**File Access Info**
C:\MY\PATH\MYFILENAME.PDF
Created: 6/6/2022 1:30:42 PM
Last Accessed: 6/6/2022 4:30:23 PM
Last Modified: 6/6/2022 4:30:23 PM

See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.