View Full Version : [SOLVED:] Creating date and time stamp
msa722
06-21-2022, 08:50 AM
Dear All,
How to create a date and time stamp on the workbook after every modification (last modified on: XX) in VBA?
Thanks,
Logit
06-21-2022, 09:39 AM
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
06-21-2022, 10:37 AM
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
Why would you ?
Excel does it automatically.
29861
georgiboy
06-22-2022, 01:45 AM
Another option might be track changes? Built into Excel.
msa722
06-22-2022, 08:36 AM
Thanks everyone, this was helpful.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.