Jerry is probably right. That being said, this function should get you the
date & time the file was last modified. However, storing that information inReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12158-file-attributes.htmlReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12158
a table may not be a good idea.
Dim fso, f
Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fso.GetFile(filespec)
ShowDateModified = f.DateLastModified
"filespec" is the full path and filename of the file in question. You may
or may not need a reference to the Microsoft Scripting Runtime library.
For more info on the FileSystemObject, see: http://msdn.microsoft.com/library/de...stemObject.asp
> I need to link to a file's attributes such that if that file is updated (thus
> changing the save date and save time), I can have those attributes reported
> back (updated) to an Access table.
> Is this possible?