PICTURES..

D

Daniel

I'm assuming you wish to extract the filename and creation date & time from a
list of file in an access database?

If so, try

FileDateTime()

or

Dim oFSO As Object
Dim oF As Object

Set oFSO = CreateObject("Scripting.FileSystemObject")
Set oF = oFSO.GetFile("D:\My folder\File.TXT")
Debug.Print F.DateCreated

Set oF = Nothing
Set oFSO = Nothing

You can also find VB example that you could use/modify at
http://vbnet.mvps.org/index.html?code/fileapi/filedatetime.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top