View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
papou[_2_] papou[_2_] is offline
external usenet poster
 
Posts: 112
Default 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,