I've got an app that imports and files that i drop in a given folder; after importing them, it moves them to a 'done' folder.

I would like to be able to automate the deletion of the files from the 'done' folder when they are a year old; does anyone know how to retrieve the last modified date for a file using VBA?

Thanks

Mike

Try FileDateTime()

Mike,

I found this at another site:

http://www.mvps.org/access/modules/mdl0051.htm

HTH

Skip

Thanks both... looks promising...

skiphooper,

Great link, am gonna add that one to my sample database thread!
Folders & Files - List / Open / Attributes / Copy / Delete / New (http://www.access-programmers.co.uk/forums/showthread.php?p=278501#post278501)