Creating a "Last updated" field in Excel

[jme5343]

I have a form that gets updated every couple days. It's stored on the shared drive and I'd like it to auto fill everytime it's updated and saved. This way people can easily tell when it was changed.

Muchas Gracias 🙂

 

[Thraxen]

Here's a way to do it... I found this via Google:

Here is how you can include the time that an Excel file was updated, i.e. saved. Follow these instructions to add the code

- Hit Alt-F11, you're now in the VBA environment.
- Locate your file in VBA project
- Double left click on that file name
- Locate "ThisWorkbook" in your current file
- Paste the code in the white window
- Return to Excel with again Alt-F11

You will have to modify the sheet name and range you want the date placed, but this should get you going, at least in excel.

the code

Private Sub Workbook_Beforesave(ByVal saveasiu As Boolean, Cancel As Boolean)

Sheets(1).Range("A1").Value = Now

End Sub

This seems to work just fine. You just have to adjust the "Sheets(1)" and "Range("A1")" in the code to match the sheet and field you want the save date placed in your Excel sheet. The date in the field will automatically change when you save the document.

 

[jme5343]

Thank you Thraxen, believe it or not my google skills are usually pretty decent. Looks like I gave up too soon.

Thanks again, I appreciate it.