Get LastUpdate info of files

[AccessVB]

Hi Everyone,
Trying to find a function that would grab the last edit date of files (spreadsheets, word docs etc) and pass it on to a variable. I would appreciate it if someone could point me in the right direction.

 

[YoshiCD]

AccessVB,

I don't know much about it, but i'm sure the FileSystemObject can do this..

You reference the Microsoft Scripting Runtime Library in your project.

Do a keyword search for FileSystemObject

I hope this works for you.

 

[paulbent]

Can use the FileSystemObject (FSO). Set a reference to the Microsoft Scripting Runtime.

Dim objFSO As New FileSystemObject
Dim objFile As File

Set objFile = objFSO.GetFile("x:\path\myfile.xls&quot
Debug.Print objFSO.DateLastModified

Set objFile = Nothing
Set objFSO = Nothing

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[AccessVB]

Thanks you two. I will try it. Greatly appreciate your help.