View Single Post
 
Old 06-30-2019, 05:11 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

I'm not sure what the point of generating the list in a separate document would be. Nevertheless, that could be done by inserting:
Documents.Add
before:
Set Rng = ActiveDocument.Range.Characters.Last
and delete or comment-out:
Code:
    If .Characters.First.Previous <> vbCr Then .InsertAfter vbCr
    .InsertAfter Chr(12)
    .Collapse wdCollapseEnd
As for the sorting, that could be accomplished by inserting:
Code:
      .Sort ExcludeHeader:=True, FieldNumber:="Column 1", CaseSensitive:=False, _
        SortFieldType:=wdSortFieldAlphanumeric, SortOrder:=wdSortOrderAscending
anywhere within the:
Code:
With Tbl
...
End With
block.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote