![]() |
|
#10
|
||||
|
||||
|
Maybe something like this
Code:
Sub GatherRound()
Dim aRng As Range, aRngHead As Range, aDoc As Document, aDocNew As Document, aTbl As Table, aRow As Row
Dim sNum As String
Set aDoc = ActiveDocument
Set aRng = aDoc.Range
Set aDocNew = Documents.Add
Set aTbl = aDocNew.Tables.Add(aDocNew.Range, 1, 2)
aTbl.Cell(1, 1).Range.Text = "Heading"
aTbl.Cell(1, 2).Range.Text = "Text"
With aRng.Find
.ClearFormatting
.Replacement.ClearFormatting
.Text = "[Red]"
.Forward = True
Do While .Execute
aRng.Start = aRng.Paragraphs(1).Range.Start
Set aRow = aTbl.Rows.Add
If aRng.ListFormat.ListType = wdListNoNumbering Then
aRow.Cells(2).Range.FormattedText = aRng.FormattedText
Else
sNum = aRng.ListFormat.ListString
aRow.Cells(2).Range.Text = sNum & vbTab & aRng.Text
End If
Set aRngHead = aRng.GoToPrevious(wdGoToHeading)
aRngHead.End = aRngHead.Paragraphs(1).Range.End - 1
aRow.Cells(1).Range.Text = aRngHead.ListFormat.ListString & vbTab & aRngHead.Text
aRng.Collapse Direction:=wdCollapseEnd
aRng.End = aDoc.Range.End
Loop
End With
End Sub
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help with creating a script with VBA | lenziwag93 | Excel Programming | 1 | 04-20-2022 12:57 AM |
| Need Help to Script to align all the tables only as of a section to end of doc? | Cendrinne | Word VBA | 4 | 04-05-2021 11:37 AM |
| Creating a master spreadsheet for sorting information | Notsonerdy | Excel Programming | 8 | 05-31-2016 04:39 AM |
| Creating a list and sorting alphabetically. | irvsax | Word | 4 | 09-04-2013 11:47 PM |
Creating a sorting method.
|
Balliol | Word | 2 | 07-25-2013 06:18 AM |