INSERT DATE

[Pete C]

Does anyone know if it's possible to insert the last modified date of a
document into a excel worksheet?

Thanks

 

[Ron de Bruin]

For Excel 2000 and higher you can use this

Sub test()
Sheets("Sheet1").Range("A1").Value = _
ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")
End Sub

 

[FrankB]

-----Original Message-----
Does anyone know if it's possible to insert the last modified date of a
document into a excel worksheet?

Thanks


.
You can also use a "Footer" to put the current date,

time, file name etc. etc. and have it print on the bottom
of the page.