You can also DATE and NOW ( VBA Functions) to enter a date or a timestamp in a cell using a VBA code.
How? - Microsoft Community Windows 10 Word 365 File Name Time Stamp Automation w/o VBA - Windows 10 Forums I have a macro which I use in word to save the file with date rev and timestamp added to the filename. A DATETIME or TIMESTAMP value can include a trailing fractional seconds part in up to microseconds (6 digits) precision. TypeText Text:=vbTab End Sub Macro to remove all timestamps from comments & track changes but not remove author name. Then click the drop-down part of the “Macros” button in the “Macros” button group. However, if you want to track both the old and new values, you have to add a record for each field. Using this method, each time you open and close Notepad, a timestamp is created to time your activities more efficiently. Sub OrdinalDateStamp() Dim lngUS As Long Dim oRng As Word. The following macro can be used to insert the date and time: Sub Timestamp() Selection. Timestamp macro word However I want to be able to do this in ACCESS for automation purposes.
