Creating date and time stamp

[msa722]

Dear All,

How to create a date and time stamp on the workbook after every modification (last modified on: XX) in VBA?

Thanks,

[Logit]

Here's an example :


Sub SaveIt()Dim dt As String, wbNam As String

wbNam = "Apple_"
dt = Format(CStr(Now), "yyy_mm_dd_hh_mm")
ActiveWorkbook.SaveAs Filename:= wbNam & dt End Sub

https://www.mrexcel.com/board/threads/vba-macro-to-save-file-appending-date-time-stamp-to-filename.546829/#post-2700187

[Paul_Hossler]

Dear All,

How to create a date and time stamp on the workbook after every modification (last modified on: XX) in VBA?

Thanks,
Do you want it as part of the file name or on a Log Sheet in the workbook? I've done it both ways

[snb]

Why would you ?
Excel does it automatically.

29861

[georgiboy]

Another option might be track changes? Built into Excel.

[msa722]

Thanks everyone, this was helpful.