| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shared Workbook Won't Save | Excel Discussion (Misc queries) | |||
| How to save a workbook to an active Web Page? | Excel Discussion (Misc queries) | |||
| Cannot save shared workbook | Excel Worksheet Functions | |||
| Can you disable the save function from a shared workbook | Excel Discussion (Misc queries) | |||
| Shared workbook - to save or not to save | Excel Discussion (Misc queries) | |||
Linear Mode
