VBA Getting date from properties of a text file

Question

I'm trying to grab the date that a specific text file was uploaded onto the computer. The date isn't in the actual text file, instead you have to right-click then go to properties to view the date. I need to read the date into a variable.

I have no idea where to start to try and get this done.

Thank you,

Jesse Smothermon

score 6 · Accepted Answer · edited May 23 '17 at 12:23

6

If the built in FileDateTime() isnt what your after you can use the FSO:

Dim FSO As Object: Set FSO = CreateObject("Scripting.FileSystemObject")
Dim objFile As Object: Set objFile = FSO.Getfile("C:\bleep\bloop.file")

Debug.Print "Date created: " & objFile.DateCreated
Debug.Print "Date last accessed: " & objFile.DateLastAccessed
Debug.Print "Date last modified: " & objFile.DateLastModified

If its a date in an extended attribute check this out.

edited May 23 '17 at 12:23

Community

1
1

answered May 11 '11 at 20:34

Alex K.

171,639
30
264
288

2

Do not use `As Object`. That leads to late binding, which sucks. Use a proper reference and `As New Scripting.FileSystemObject` and `As Scripting.File` – Tomalak May 11 '11 at 20:37
Worked perfectly, Thank you (I'll accept answer once it lets me) – Jesse Smothermon May 11 '11 at 20:37
@Tomalak: Late binding has its place, though I agree that this isn't it. – RolandTumble May 11 '11 at 20:55
@Roland: Yes it has - in VBScript. ;-) – Tomalak May 11 '11 at 20:56
1

@Tomalak: Also when you may have to allow for different versions of, say, Office across your installation domain. – RolandTumble May 12 '11 at 18:39

VBA Getting date from properties of a text file

1 Answers1