File Date as a Function

gutknebr · May 17th, 2002, 12:11 PM

Is there an excel function that will return the latest date the file was saved in the contents of a cell?

bergy · May 17th, 2002, 12:38 PM

Quote:

On 2002-05-17 11:11, gutknebr wrote:
Is there an excel function that will return the latest date the file was saved in the contents of a cell?

I am not sure about an Excel formula method, but there is a VBA function. The following line would put the last saved date in cell A1.

Range("A1").Value = FileDateTime("The file name")

where "The file name" is the name of the file you ar working on. Note that the file has to be saved at least one time before doing this or else it will cause an error.

Chris Davison · May 17th, 2002, 12:40 PM

(couldn't see anything in any of the functions)

Rocky E · May 17th, 2002, 12:40 PM

Hi,

Well not directly that I am aware of, but just a one line of VBA and you are in business.

Code:

Function LastSaveTime() As Date
LastSaveTime = ActiveWorkbook.BuiltinDocumentProperties.Item("Last Save Time")
End Function

Well I assumed you meant the current Excel file, sorry...

_________________
Hope this helps!

Rocky

"Be not the first by whom the New are try'd,
Nor yet the last to lay the Old aside."
Alexander Pope (1688-1744).

[ This Message was edited by: Rocky E on 2002-05-17 11:44 ]

[ This Message was edited by: Rocky E on 2002-05-17 11:46 ]

gutknebr · May 29th, 2002, 06:54 AM

Thanks. That works great the first time I enter the function. The problem I have, is that if I save the file at a later point in time, the cell value does not update (even if I click Recalculate Cells). The only way the cell updates to the new date is to select the cell and hit the "enter" key. How can I have this update automatically when the file is saved?

May 17th, 2002, 12:40 PM	#4
Rocky E Board Regular Join Date: Feb 2002 Location: North Alabama, USA Posts: 105	Hi, Well not directly that I am aware of, but just a one line of VBA and you are in business. Code: Function LastSaveTime() As Date LastSaveTime = ActiveWorkbook.BuiltinDocumentProperties.Item("Last Save Time") End Function Well I assumed you meant the current Excel file, sorry... _________________ Hope this helps! Rocky "Be not the first by whom the New are try'd, Nor yet the last to lay the Old aside." Alexander Pope (1688-1744). [ This Message was edited by: Rocky E on 2002-05-17 11:44 ] [ This Message was edited by: Rocky E on 2002-05-17 11:46 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 17th, 2002, 12:11 PM	#1
gutknebr New Member Join Date: May 2002 Posts: 8	Is there an excel function that will return the latest date the file was saved in the contents of a cell?

May 17th, 2002, 12:40 PM	#3
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	(couldn't see anything in any of the functions)

May 29th, 2002, 06:54 AM	#5
gutknebr New Member Join Date: May 2002 Posts: 8	Thanks. That works great the first time I enter the function. The problem I have, is that if I save the file at a later point in time, the cell value does not update (even if I click Recalculate Cells). The only way the cell updates to the new date is to select the cell and hit the "enter" key. How can I have this update automatically when the file is saved?