Find the file date and time for another excel file

[storm925]

Hello All,
I'm looking for a formula or simple macro that will let me find the date and time of another excel file and post it into the cell of an open worksheet.

Example:
In cell "L1" of the current opened worksheet, I want to paste the "directory" date and time for the following file... J:\Control\NightCount.csv

Thanks,
Ben

 

[storm925]

After querying the web, I found my answer. I thought I would share it here in case someone searches for it through this forum.

Here is a simple macro to find the creation date of the current opend file...

Sub Open_File_Creation_Date()
Range("L1").Select
ActiveCell.Value = _
Application.ActiveWorkBook.BuiltinDocumentProperties("Creation Date")
End Sub

Here is what I was looking for, a simple macro to find the date and time of another file...

Sub Another_File_Creation_Date()
Range("L1").Select
ActiveCell.Value = _
FileDateTime("J:\Control\NightCount.csv")
End Sub