Formula for file modified date
Maybe this
Sub sonic()
moddate = Format(FileDateTime("c:\book2.xls"), "m/d/yy h:m ampm")
MsgBox moddate
End Sub
Mike
"Pastel Hughes" wrote:
I have an Excel file (call it file A) that draws information from a separate
file (file B)that gets updated periodically. I would like to have the date
that file B was last modified appear in a cell in file A. I've looked
through most of the excel formulas but can't seem to find one that will do
this. Is this doable?
|