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.