Excel Last Date Saved

[wyone]

OK so please bear with me as I am truly a newbie to programming. I use Excel 2003 extensively in my business. I am trying to insert the last saved date in a cell on one of my worksheets. We use these spreadsheets in our estimating programs and sometimes lose track of when they were saved. Of course we can look in the details in the explorer window, but it would be great to just have it inserted in a cell automatically.

I am not trying to verify when certain cells or rows or columns are changed, but only keep track of when the workbook is last saved.

I have read a few of the threads regarding this, and frankly am very confused. I can see there is a way to do it with VBA, but I have no knowledge of VBA other than what I read on here.

I realise it might be too much to ask for lessons for this type of thing, so if anyone has a good reference source for me to start learning I would really appreciate it.

Thanks in advance for any help!

 

[SkipVought]

Hi,

Check out BuiltinDocumentProperties Property in VB Help

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}

 

[AnotherHiggins]

There was a very similar question asked and answered just a few days ago:
thread707-1447942

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.