Steve Goodhall
steve at goodhall.info
Wed Jul 18 08:04:46 CDT 2012
Yes. You need to use the scripting.filesystem object. If you can't find enough information by Googling, e-mail me off list and I will send some samples tonight. Regards, Steve Goodhall, MSCS, PMP 248-505-5204 ----- Original Message ----- From: Access Developers discussion and problem solving To:"Access Developers discussion and problem solving" Cc: Sent:Wed, 18 Jul 2012 07:54:34 -0500 Subject:[AccessD] How to Obtain the ?Date Modified? attribute of an External Excel File All, I have an Access 2007 application that obtains data from several Excel Files (Using both Linked Tables and Windows Automation). I would like to be able to obtain the Excel files Data Modified field in order to place this date-time on an Access Report. Is it possible to obtain this info? Thanks, Brad