Thread
:
Last Save Time for non active shared workbook
View Single Post
#
1
Posted to microsoft.public.excel.programming
papou[_2_]
external usenet poster
Posts: 112
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,
Reply With Quote
papou[_2_]
View Public Profile
Find all posts by papou[_2_]