![]() |
|
|
|
#1
|
|||
|
|||
|
Hey, the script works well in terms of pulling the data before it. I am not sure if its beacuse the document is so large it starts to not respond and I have to hard restart Word. This only happens if the when the script has to find many cases of the value. it does about 80% of the document then it repeats the same data for pages on end. As for pulling lists in front of our search value. Not getting any data. It could be that immeditly after our search value there isnt a list but another one of the "tags" I use.
Example: [Red] [Blue] and/or [Red] #ABC
that may be an issue not to sure. Again help on this has been more than enough so many thanks for input. |
|
#2
|
|||
|
|||
|
Code:
Sub GatherRoundUpdated()
Dim aRng As Range, aRngHead As Range, aDoc As Document, aDocNew As Document, aTbl As Table, aRow As Row
Dim sNum As String, lastPosition As Long
Set aDoc = ActiveDocument
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"
Set aRng = aDoc.Range
aRng.Find.ClearFormatting
aRng.Find.Replacement.ClearFormatting
aRng.Find.Text = "[Red]"
aRng.Find.Forward = True
Do While aRng.Find.Execute
If aRng.Start = lastPosition Then Exit Do ' Exit loop if stuck at the same position
lastPosition = aRng.Start
Set aRngHead = aRng.GoToPrevious(wdGoToHeading)
If Not aRngHead Is Nothing Then
aRngHead.End = aRngHead.Paragraphs(1).Range.End - 1
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
aRow.Cells(1).Range.Text = aRngHead.ListFormat.ListString & vbTab & aRngHead.Text
End If
aRng.Collapse Direction:=wdCollapseEnd
aRng.End = aDoc.Range.End
Loop
' Clean up
Set aRng = Nothing
Set aDoc = Nothing
Set aDocNew = Nothing
Set aTbl = Nothing
Set aRow = Nothing
End Sub
|
|
|
|
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 |