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

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 




More information about the AccessD mailing list