The File object has a DateLastModified property...
Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fso.GetFile(fpath)
str = f.DateLastModified
-or-
The free Excel add-in "List Files" does everything you describe
plus a little bit more. Download from...
http://www.realezsites.com/bus/primitivesoftware
No registration required.
--
Jim Cone
San Francisco, USA
"dd" <dd.dd wrote in message ...
I have a workbook that works as a fileindex to show paths, files and
hyperlinks ot the files.
Is there a way I can include the date the file was created (date attribute),
as a new column to my worksheet?
DDawson
Scotland