Displaying the date a workbook was modified

  • Thread starter Thread starter Bodene
  • Start date Start date
B

Bodene

How doe I insert the date on which the workbook was last saved into a
worksheet?
 
This code should log the save date and time to cell A1 of the active sheet
in the book.

Range("A1").ActiveWorkbook.BuiltinDocumentProperties(12).Value

How and where you use the code depends if you need the refreshing of the
data to be automatic or manual.

HTH
Matt
 
The following should work. In this case it logs the information to cell A1 of
sheet 1 in the active workbook.

ActiveWorkbook.Sheets(1).Range("A1") =
ActiveWorkbook.BuiltinDocumentProperties(12).Value

Note that the document should have been already saved once or an error will
arise since the value will be empty.

HTH
Matt
 
Thank you for these answers - but what I was looking for was a function
similar to one I used to use on Lotus 123 -
@info("last-revision-date"). Is there anything similar in Excel?
 
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

Display last date workbook was modified? 1
Sharing workbooks limitations - Merged Cells 12
How do I display the last updated date in the page header? 2
Displaying when workbook was last updated 4
Insert Worksheet At the End Of Workbook 2
Date last modified - for entire workbook 3
date file modified 2
Create/modify date for specific sheets? 3

Back
Top