Last Save Time for non active shared workbook

  • Thread starter Thread starter anon
  • Start date Start date
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,
 
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

Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
shared file ! 2
Last Save date/time and User for a specific sheet in a shared work 8
Save ActiveWorkbook dilemma 3
All Workbook Saved except This Workbook - Part2 3
Copy two sheets from workbook & create new workbook 8
Open Workbook to Specific Cell 5
auto save shared workbook 2

Back
Top