word for mac - insert last revision date

#Word for mac insert last revision date code#

Then it inserts the last modified time in the cell. Step 3: Then save and close this code, and go back to the worksheet, in a blank cell, enter the formula of =ModDate(), and press the Enter key. ModDate = Format(FileDateTime(ThisWorkbook.FullName), 'm/d/yy h:n ampm') Step 2: Click Insert > Module, and paste the following macro in the Module Window. Insert last modified time of workbook in Excel Note: you can modify the destination cell in the VB according to your needs. And then the created date and last modified date will be inserted into cell A1 and cell A2 separately. Step 3:Press the F5 key to run this macro.

Range('A2').Value = Format(ThisWorkbook.BuiltinDocumentProperties('Last Save Time'), 'short date') Range('A1').Value = Format(ThisWorkbook.BuiltinDocumentProperties('Creation Date'), 'short date') VBA code: Insert both created time and last modified time in Excel Sub Workbook_Open() Step 1: Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window. Insert both created time and last modified time in Excel The following VBA macros will help you insert the created time and last modified time of current workbook information in cells directly. Step 2: In the Advanced Properties dialog box, you will see the created time and last modified time under Statistics tab. In Excel 2010/2013, click the File > Info > Properties > Advanced Properties. In Excel 2007, click the Office button > Prepare > Properties, and a Document Properties bar will be displayed below the toolbar, click Document Properties > Advanced Properties, see screenshots: Step 1: Open the Advanced Properties dialog box: It is invalid in Excel 2007.Īctually, we can get the both created time and last modified time of current workbook in Document Properties dialog box. Note: This way is only available in Microsoft Excel 2010/2013. Under the Related Dates title, it lists the last modified time, created time, and last printed time. We can find out the exact created time and last modified time of current workbook in backstage view of Microsoft Excel 2010 / 2013.Ĭlick the File > Info, and in the right side of backstage view it displays the Related Dates information. Insert the created time and last modified time in cells/header/footer with Kutools for Excel

#Word for mac insert last revision date code#

Insert the created time and last modified time in cells in Excel with VBA code Get the created time and last modified time in Excel with Advanced Properties function Get the created time and last modified time in Excel with Info command This article will talk about ways to get the created time and last modified time of current workbook information, and insert the created time and last modified time of current workbook information in cells in Excel. Get and insert the created time and last modified time in cells

Word for mac - insert last revision date