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

Steve and Gustav,

Thanks for the help, I really appreciate it.

Both methods work nicely.

I owe you both a beer  :-)

Brad


-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of Gustav Brock
Sent: Wed 7/18/2012 8:37 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] How to Obtain the ?Date Modified? attributeof	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 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.