Last Save Time for non active shared workbook
 

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,

Last Save Time for non active shared workbook
 

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

HTH
Cordially
Pascal

"anon" a écrit dans le message de news:
...
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,