Dir command from Access/VBA

[smitan]

I would like know the date of a file in my Access-project.
The DIR command gives me the name, no more.
Is there another possibility to get this date?

Thanks
Hans

 

[KenReay]

Hi

See the FileSystem object, I have not done this, but I believe it has methods which will allow you to retrieve file properties

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[oharab]

It sure does:
Dim FSO as Object
Dim File AS Object
Set FSO=CreateObject("Scripting.FileSystemObject&quot
Set File=FSO.GetFile("C:\File.txt&quot
Debug.Print "Created on", File.DateCreated
Debug.Print "Last Modified on", File.DateLastModified
Debug.Print "Last Accessed on", File.DateLastAccessed

hth

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"
NoFX-The Decline
----------------------------------------------

 

[smitan]

Thanks a lot you two.
Good solution.
Hans