Display "Last updated date" for the Workbook (without usin..

CRayF · External Since: Sep 18, 2005 Posts: 4

Is there a way to diasplay in a cell the "Last updated date" the workbook was
saved without using a marco?
thanks in advance,

Bob Phillips · External Since: Jun 08, 2004 Posts: 5103

don't think you can.

--
HTH

Bob Phillips

"CRayF" <CRayF RemoveThis @discussions.microsoft.com> wrote in message
news:41747375-B34C-4DDC-A2DD-E4FE1BBB7D07@microsoft.com...
> Is there a way to diasplay in a cell the "Last updated date" the workbook
was
> saved without using a marco?
> thanks in advance,

Rich Hartmann · External Since: Oct 28, 2009 Posts: 1

Is there a macro that can display the last updated date in a spreadsheet?
Rich

"Bob Phillips" wrote:

> don't think you can.
>
> --
> HTH
>
> Bob Phillips
>
> "CRayF" <CRayF.DeleteThis@discussions.microsoft.com> wrote in message
> news:41747375-B34C-4DDC-A2DD-E4FE1BBB7D07@microsoft.com...
> > Is there a way to diasplay in a cell the "Last updated date" the workbook
> was
> > saved without using a marco?
> > thanks in advance,
>
>
>

Gord Dibben · External Since: Feb 23, 2004 Posts: 9178

Sub lastsavetime()
With ActiveSheet
.Range("A1").Value = "Last Saved "
.Range("B1").Value = Format(ThisWorkbook.BuiltinDocumentProperties _
("Last Save Time"), _
Format("yyyy-mmm-dd hh:mm:ss"))
End With
End Sub

Gord Dibben MS Excel MVP

On Wed, 28 Oct 2009 11:37:01 -0700, Rich Hartmann <Rich
Hartmann.RemoveThis@discussions.microsoft.com> wrote:

>Is there a macro that can display the last updated date in a spreadsheet?
>Rich
>
>"Bob Phillips" wrote:
>
>> don't think you can.
>>
>> --
>> HTH
>>
>> Bob Phillips
>>
>> "CRayF" <CRayF.RemoveThis@discussions.microsoft.com> wrote in message
>> news:41747375-B34C-4DDC-A2DD-E4FE1BBB7D07@microsoft.com...
>> > Is there a way to diasplay in a cell the "Last updated date" the workbook
>> was
>> > saved without using a marco?
>> > thanks in advance,
>>
>>
>>