time stamps detailing last save time

hi,

what is the best way of obtaining the last save time of another workbook/sheet. i want to create a sheet which lists the last time another workbook was saved?

any ideas?

Follow the link in this site :

http://www.excelforum.com/showthread.php?t=332359

Hope this helps,
theDude

thanks for that, this gives me the time stamp for the active workbook, but how could i link it to another workbook or sheet to see if a user has saved their spreadsheet.

Try this (replace file reference in BOLD below with your own):

Sub ShowFileAccessInfo()
Dim fs, f, s
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile("C:\Temp\Workbook2.xls")
s = UCase(f) & vbCrLf
s = s & "Created: " & f.DateCreated & vbCrLf
s = s & "Last Accessed: " & f.DateLastAccessed & vbCrLf
s = s & "Last Modified: " & f.DateLastModified
MsgBox s, 0, "File Access Info"
End Sub

Hope this helps,
theDude

Thanks again, one final question if i want to know the save time of several other worksheets used by other users how could i do this so i would get a list of save times on an excel sheet that i could monitor for save times of other users.