Skip to main content

Path property

Table of contents
  1. Syntax
  2. Examples

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

Syntax

object.Path

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

Examples

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

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

Function 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
    Debug.Print s
End Function

Run this code in Immediate Window:

Debug.Print ShowFileAccessInfo("D:\helloworld.txt")

Result:

D:\HELLOWORLD.TXT
Created: 2022/4/14 9:36:47
Last Accessed: 2022/4/14 9:36:47
Last Modified: 2022/4/14 14:16:17

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>