¡¡j The cell must be formatted properly to display the date and/or time. o

LastSaved(FullPath) The argument is

FullPath—A string showing the full path and filename of the file in question.

Function LastSaved(FullPath As String) As Date LastSaved = FileDateTime(FullPath) End Function

Figure 4.2

Retrieve date and time of last save.

1 I 1IJ:'JJi'U::':I:LIM H M U.astSavgdi'CAEiicgl V&A 2ÛÛ3 by -eler & Sy.'sladVChaplpr 4 samples.xls')

0 0

Post a comment