Recording the last saved date of an external file in a cell
 

Within a cell on a spreadsheet I want to record the last saved (or modified)
date of another (non Excel) file.

Example - I have a Powerpoint presentation that was last saved on 01/09/03.
I want cell A1 of an Excel file to display "01/09/03" and update when the
Powerpoint file is subsequently saved. Is this possible?

The excel file will be opened regularly, so some form of Auto_Open macro or
VBA code that updates cell A1 will be perfect.

Thanks in advance for any help!

Recording the last saved date of an external file in a cell
 

Perfect! Thanks


"Tom Ogilvy" wrote in message
...
? filedatetime("c:\Briefing Aug 03a.ppt")
8/6/2003 2:36:23 PM

so
Private Sub Workbook_Open()
With ThisWorkbook.Worksheets("Sheet1").Range("A1")
.Value = _
filedatetime("c:\Briefing Aug 03a.ppt")
.NumberFormat = "mm/dd/yyyy"
End With

End Sub

Regards,
Tom Ogilvy


"Mickey Mouse" <@ wrote in message
...
Within a cell on a spreadsheet I want to record the last saved (or
modified)
date of another (non Excel) file.

Example - I have a Powerpoint presentation that was last saved on
01/09/03.
I want cell A1 of an Excel file to display "01/09/03" and update when
the
Powerpoint file is subsequently saved. Is this possible?

The excel file will be opened regularly, so some form of Auto_Open macro
or
VBA code that updates cell A1 will be perfect.

Thanks in advance for any help!