PDA

View Full Version : date of last backup



lior03
09-20-2007, 12:11 PM
hello
i am using a macro to craete a backup of workbook.is it possible to add a
msgbox with the last time a backup was made?

On Error Resume Next
If MsgBox("Are you sure ?", vbYesNo + vbQuestion, "update a backup at C:\paz.xls") = vbNo Then Exit Sub
ActiveWorkbook.SaveCopyAs "C:\paz.xls"


i want to let the user decide whether the time has come for a new backup.
how can excel provide information for a closed workbook?
thanks

Bob Phillips
09-20-2007, 01:12 PM
MsgBox ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")

mdmackillop
09-20-2007, 01:27 PM
Check out
DateLastModified Property

in VBA Help