[AccessD] How to Obtain the ?Date Modified? attribute of anExternal Excel File

Hi Brad

I thing FileDateTime could be used:

datFileDate = FileDateTime("d:\folder\yourfile.xlsx")

/gustav


----- 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