Getting File Information (Access 2003)

Topic

New Reply

I have a VB script that I’m working on and would like to bring in the modification date of a text file I’m using. I have the file name and the path, but do not know how to retrieve the information from the windows directory.

Thanks in advance,
Drew

Reply | Quote

Replies

You can use Scripting.FileSystemObject for this:

Dim strFile As String
Dim dtmModified As Date
strFile = …
dtmModified = CreateObject(“Scripting.FileSystemObject”).GetFile(strFile).DateLastModified

Reply | Quote

Thanks!

Reply | Quote