Posted by JAF on May 15, 2000 12:42 AM
I'm trying to use the BuiltInDocumentProperties command to obtain the following information about the workbook: "Last Saved By" and "Date/Time Last Saved".
I can do the "Last Saved By" without any problem using: MsgBox "Last Saved By: " & ThisWorkbook.BuiltinDocumentProperties("Last Author")
When I try to get the Date/Time using:
MsgBox "Last Saved At: " & ThisWorkbook.BuiltinDocumentProperties("Last Save Time")
I get the following error
Run Time Error '-2147467259 (80004005)'
Any suggestions as to what is going wrong and how to fix it?