Workbook Date last saved

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Does anyone know how to return the workbook DATE that it
was last saved ?

I can open the workbook with Workbook.Open so that it is
active, but would like to know the workbook's date (the
dateproperty in Window's Explorer) so I can test to see if
the workbook data file is the most recent.

Thanks for any help.
 
DateValue(ActiveWorkbook.BuiltinDocumentProperties("Last Save Time"))
 
You must log in or register to reply here.

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

Strange behaviour 4
Excel Protection 2
COM addin won't connect when workbook opened via another workbookfrom another instance 3
Saving the revised date for any workbook. 3
Welcome screen... 1
Why is Referenced Workbook Saved When ActiveWorkbook is Saved? 1
Disable Worksheet_SelectionChange macros 2
Excel 2007 Access the Content Created File property in vba 3

Back
Top