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

L

Legacy 55058

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

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

RAM

Well-known Member
Joined
Oct 4, 2004
Messages
1,862
What about File - Properties and the Statistics tab?

RAM
 
L

Legacy 55058

Guest
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

Well-known Member
Joined
Oct 4, 2004
Messages
1,862
Probably, but I can't help you on that. Sorry

RAM
 
L

Legacy 55058

Guest

ADVERTISEMENT

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

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
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
 
L

Legacy 55058

Guest
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

Legend
Joined
Feb 18, 2002
Messages
13,690
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.
Code:
Sheet1.Range("$A$1").Value = ActiveWorkbook.BuiltinDocumentProperties.Item("Last Save Time")

HTH

lenze
 

Watch MrExcel Video

Forum statistics

Threads
1,118,068
Messages
5,570,003
Members
412,304
Latest member
citrus
Top