DATE MODIFIED

's Computer Specifications

Hi
I would like some code which places the "date modified" of an external
workbook into a cell.
Can anyone help,
Thanks
Simon

's Computer Specifications

'For date
Range("A3") = Datevalue(filedatetime("d:\sales.xls"))

'For date and time
Range("A3") = filedatetime("d:\sales.xls")

--
Jacob

"Simon" wrote:

> Hi
> I would like some code which places the "date modified" of an external
> workbook into a cell.
> Can anyone help,
> Thanks
> Simon

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I access date created and date modified for Contacts	=?Utf-8?B?cmpiYXJuaGFydA==?=	Microsoft Outlook Contacts	1	6th Aug 2007 01:09 PM
Items not archived with modified date older than the date specifie	=?Utf-8?B?b29sb25namVu?=	Microsoft Outlook Discussion	0	26th Apr 2006 07:10 PM
Change auto archive to received date rather than modified date	=?Utf-8?B?S2VubiBG?=	Microsoft Outlook Discussion	1	29th Sep 2005 03:21 PM
Windows Explorer - Date Created and Date Modified Matching	iltf124 no spam @hotmail.com	Windows XP Help	0	4th Feb 2004 04:20 PM
Date Created, Date Modified Changed to Date CD was burned	Mark	Windows XP General	0	25th Sep 2003 10:03 PM