2
I have a MS Word document where I accumulate and frequently modify certain data in a very long table. So I would like to sort the data by latest modification time in the rows. Of course if I add a column where I enter the modification time by hand this would work but I would like to avoid this if possible.
OK as the question has been put on hold with the request to make it more concrete, I am trying to modify it accordingly.
What I specifically want (and then I can do it myself) is this:
Since MS Word has features like change tracking, each modified portion of text must have its last modification time recorded in some form.
My question is then - how can I access this information from within a Visual Basic macro? I mean something like ThisTable.ThisCell.ModificationTime() or ThatTable.CurrentRow.LastModificationSessionTime() or something similar.
So when you modify an element you want it to move to the top of the table? Or you want it done historically? – Raystafarian – 2015-01-31T11:09:36.310
@Raystafarian I would like to sort it in various ways, including this one – მამუკა ჯიბლაძე – 2015-01-31T11:54:32.310
If you don't timestamp the entries, what are you planning to use to sort on? AFAIK, tables don't automatically record when each value is entered. – fixer1234 – 2015-02-01T00:44:03.343
@fixer1234 Word has Track Changes feature (in the Review tab), so it is definitely recorded somewhere. Anyway the Excel solution below (with automatic timestamping) would suit me, except it is for one column of data while I have several. – მამუკა ჯიბლაძე – 2015-02-01T05:56:27.253
I believe track changes works at the session level. So at one sitting, you go in and create or modify a bunch of rows and then save the result. All of those entries would be part of the same change. You wouldn't have a basis to sort by time within the set. – fixer1234 – 2015-02-01T07:15:30.353
@fixer1234 When looking at revisions, I see separate modification times for revisions of each chunk of text, and this is OK for me - if I can sort by most recent session at which the row has been modified that is all I want – მამუკა ჯიბლაძე – 2015-02-01T07:51:53.380