Get Saved date from spreadsheet

[jeffwest1]

I can't seem to find a piece of VBA code that will give me the last saved date of the workbook so that i can show this in a cell of a sheet, anyone know of anything that would work??

--------------------------------
Luke: But tell me why I can't...
Yoda: No, no, there is no why. Nothing more will I teach you today. Clear your mind of questions.

 

[HarleyQuinn]

You can get this from the "Last Save Time" item of the ActiveWorkbook.BuiltinDocumentProperties collection.

Hope this helps

HarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!

You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before post

 

[jeffwest1]

Brilliant, cheers.

--------------------------------
Luke: But tell me why I can't...
Yoda: No, no, there is no why. Nothing more will I teach you today. Clear your mind of questions.

 

[HarleyQuinn]

Glad I could help

HarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!

You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before post