macro to know the modified file date

Microsoft Microsoft excel 2000 95/98/me/...
August 12, 2009 at 09:42:40
Specs: Windows XP, PENTIMUM -4/1GB
Hi,every month to process some database file we required to check weather database is modified on specific disk drive or not and what is the modified date.
can we create the macro in excel to get the modified date of the databse files from specific disk drive?

See More: macro to know the modified file date

Report •

August 12, 2009 at 09:57:50
FileDateTime ( file_path )

Sub FileModDate()
 MsgBox FileDateTime("C:\My Documents\Book1.xls")
 Range("A1") = FileDateTime("C:\My Documents\Book1.xls")
End Sub

Report •
Related Solutions

Ask Question