Last Save Time for non active shared workbook

  • Thread starter Thread starter anon
  • Start date Start date
A

anon

Hi,

In simple terms I am looking to get the 'Last Save Time' for a shared
workbook that is not open, and is on a network drive.

I know how to do this for the activeworkbook but am would like to do
it without opening the workbook in question. Is this possible?

Thanks,
 
Hi
Use the FileSystem Object eg:
MsgBox CreateObject("Scripting.FileSystemObject") _
..GetFile("\\server\dir1\dir2\dir3\book.xls") _
..DateLastModified

HTH
Cordially
Pascal
 
Back
Top