Last Save Time for non active shared workbook

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,
 
P

papou

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

HTH
Cordially
Pascal
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

shared file ! 2
Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
save user inputs from userform in a seperate workbook 6
auto save shared workbook 2
Saving Workbook in a shared drive 8
Last Save date/time and User for a specific sheet in a shared work 8
Determine if a shared workbook is open 1
Save ActiveWorkbook dilemma 3

Top