INSERT DATE

P

Pete C

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

Thanks
 
R

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
 
F

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,
Click to expand...
time, file name etc. etc. and have it print on the bottom
of the page.
 
Top