How to Automatically Update the Excel File Editing Time

This updated guide examines How to Automatically Update the Excel File Editing Time and organizes the essential facts, background, and practical takeaways in clear American English.

Instructions for updating the Excel file editing time

Step 1:

First of all we open the Excel file we want to add the edited time to the content. Press the key combination Alt + F11 to open the VBA code editor.

At Microsoft Visual Basic for Applications interface, click Insert and then select Module as shown below.

Step 2:

Then you enter the following code into the interface.

Sub Workbook_Open() Range("A21"). Value = Format(ThisWorkbook. BuiltinDocumentProperties("Creation Date"), "short date") Range("B21"). Value = Format(ThisWorkbook. BuiltinDocumentProperties("Last Save Time"), "short date") End Sub

Note A1 and B1 are the position of the two cells where the creation time and the last time Excel file was modified. This position can vary depending on where the user sets the time in the Excel data table.

Once you have entered the code, click the Run icon to run.

Finally, at the position of the 2 cells you selected will display the time of the Excel file created and the time to edit the Excel file. Time display can completely change the format if desired.

:

• Instructions on how to insert current date in Excel
• How to format dates in Excel
• How to insert the current time into Google Sheets

I wish you successful implementation!