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

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

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

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

Hi Ruan,
You would have to run a macro from ThisWorkBook,
you can see an example of such a macro with that and
a bit more in
http://www.mvps.org/dmcritchie/excel/highlite.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Ruan Walters" wrote in message ...
Thanks Chip,

The only issue I have is that the function you gave me displays the
"Save Time" after I press <enter on "=LastSaveTiem()". After that the
cell doesn't refresh when I save the Workbook again. I have to manually
refresh that cell by editing it and pressing enter to get the Last Save
Time to change.

Am I doing something wrong? I created the Function inside the "Modules"
code window.

Thanks
Ruan



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

=LastSaveTime()+Trunc(Rand())

Should make it volatile

--
Regards,
Tom Ogilvy


Ruan Walters wrote in message
...
Thanks Chip,

The only issue I have is that the function you gave me displays the
"Save Time" after I press <enter on "=LastSaveTiem()". After that the
cell doesn't refresh when I save the Workbook again. I have to manually
refresh that cell by editing it and pressing enter to get the Last Save
Time to change.

Am I doing something wrong? I created the Function inside the "Modules"
code window.

Thanks
Ruan



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!