Is there a function to show when the file was last updated?

[Legacy 55058]

Is there a function of when the file was last updated?

 

[RAM]

What about File - Properties and the Statistics tab?

RAM

 

[Legacy 55058]

Yes, that is the information I am looking for, but I am looking to have that information placed into a cell and retrieved by a function, or if there is VBA script to perform that.

 

[RAM]

Probably, but I can't help you on that. Sorry

RAM

 

[lenze]

You might start here

http://www.mrexcel.com/board2/viewtopic.php?t=44513&highlight=builtin+document

lenze

 

[Legacy 55058]

Fantastic, thank you for the info......

 

[Legacy 55058]

how do you get the function to update when the workbook opens?

 

[lenze]

When you say the function, do you mean the code, or are you using one of the formula approaches mentioned in the reference thread? If you're using the code, you can place it in the ThisWorkbook module as an On Open event. Numerous examples on the board. To get to this module, right click on the Excel icon to the left of "File" on the menu bar and choose view code, or open the VBE (ALT+F11) and select it from the left hand project explorer.

HTH

lenze

 

[Legacy 55058]

I am using the function mentioned in the thread. I noticed that it does not update the last saved time on the file that I reference within the function, unless you modify the function again.

=lastsaved("\\c:blah.blah.blah.xls")

Is there a way to have this function update when the workbook is opened. I looked into a open event, but I am by no means a VB genius.

 

[lenze]

I'm not sure about Juan's function. Perhaps he will address that. Using code, however, you can place the following as an On Open Event in the ThisWorkbook module.

Sheet1.Range("$A$1").Value = ActiveWorkbook.BuiltinDocumentProperties.Item("Last Save Time")

HTH

lenze