Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last Save Date & Time
Ruan,
You need a VBA function: Function LastSaveTime() As Variant LastSaveTime = ThisWorkbook.BuiltinDocumentProperties("Last Save Time").Value End Function Then, call this from a worksheet cell with =LastSaveTime() . -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "Ruan" wrote in message ... Hello, Is it possible to display the "Last Save Date and Time" of an Excel workbook to a specific cell? Thanks Ruan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last Save Date & Time
Chip,
The function below doesn't seem to work on my machine with Excel 97 !? I can see the "BuiltinDocumentProperties" property for Thisworkbook - I geta run time error 5.Do I need to alter the argument "Last Save Time" ? Cheers, Jason. "Chip Pearson" wrote in message ... Ruan, You need a VBA function: Function LastSaveTime() As Variant LastSaveTime = ThisWorkbook.BuiltinDocumentProperties("Last Save Time").Value End Function Then, call this from a worksheet cell with =LastSaveTime() . -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "Ruan" wrote in message ... Hello, Is it possible to display the "Last Save Date and Time" of an Excel workbook to a specific cell? Thanks Ruan |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last Save Date & Time
It isn't.
-- Regards, Tom Ogilvy Chip Pearson wrote in message ... Jason, Not all built in document properties are maintained by Excel. I guess this one isn't in 97. -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "jason" wrote in message om... Chip, The function below doesn't seem to work on my machine with Excel 97 !? I can see the "BuiltinDocumentProperties" property for Thisworkbook - I geta run time error 5.Do I need to alter the argument "Last Save Time" ? Cheers, Jason. "Chip Pearson" wrote in message ... Ruan, You need a VBA function: Function LastSaveTime() As Variant LastSaveTime = ThisWorkbook.BuiltinDocumentProperties("Last Save Time").Value End Function Then, call this from a worksheet cell with =LastSaveTime() . -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "Ruan" wrote in message ... Hello, Is it possible to display the "Last Save Date and Time" of an Excel workbook to a specific cell? Thanks Ruan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
save by & date, time | Excel Worksheet Functions | |||
Update Date, Time Only Upon Save | Excel Discussion (Misc queries) | |||
Save Date & Time | Excel Worksheet Functions | |||
Save as Current Date / Time | Excel Discussion (Misc queries) | |||
Last Save Date & Time | Excel Programming |