| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Display "Last updated date" for the Workbook (without using a macr
Is there a way to diasplay in a cell the "Last updated date" the workbook was
saved without using a marco? thanks in advance, |
|
#2
|
|||
|
|||
|
don't think you can.
-- HTH Bob Phillips "CRayF" wrote in message ... Is there a way to diasplay in a cell the "Last updated date" the workbook was saved without using a marco? thanks in advance, |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display "Last updated date" for the Workbook (without using a
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" wrote in message ... Is there a way to diasplay in a cell the "Last updated date" the workbook was saved without using a marco? thanks in advance, |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display "Last updated date" for the Workbook (without using a
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 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" wrote in message ... Is there a way to diasplay in a cell the "Last updated date" the workbook was saved without using a marco? thanks in advance, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| How do I display a graph from one workbook to another | Excel Worksheet Functions | |||
| How do I format the date in a footer to display the month in lett. | Excel Discussion (Misc queries) | |||
| Cannot display Workbook | Excel Discussion (Misc queries) | |||
| Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
