Sub CitationAlyse() ' Paul Beverley - Version 13.11.23 ' Checks citations against references myFontColour = wdColorBlue myDateColour = wdColorRed includeNotes = True notNames = "In From For Act Jan January Feb February " notNames = notNames & " Mar March Apr April NotMay June " notNames = notNames & " July Aug August Sept September Oct Initially " notNames = notNames & " October Nov November Dec December Finally " notNames = notNames & " Also As Conversely Correspondingly Consequently " notNames = notNames & " Equally Furthermore Lastly Moreover However " notNames = notNames & " Secondly Thirdly Similarly Additionally " CR = vbCr CR2 = CR & CR myScreenOff = True Dim myCol(4) myCol(0) = wdYellow myCol(1) = wdBrightGreen myCol(2) = wdRed myCol(3) = wdTurquoise myCol(4) = wdGray25 ' If text is selected, sort it If Selection.Start <> Selection.End Then Set rng = Selection.Range.Duplicate rng.Collapse wdCollapseStart rng.Expand wdParagraph Selection.Start = rng.Start Set rng = Selection.Range.Duplicate If Right(rng.Text, 1) <> vbCr Then rng.Collapse wdCollapseEnd rng.Expand wdParagraph Selection.End = rng.End End If myResponse = MsgBox("Sort selection by year?", vbQuestion _ + vbOK, "CitationAlyse") If myResponse <> vbOK Then Exit Sub If myScreenOff = True Then Application.ScreenUpdating = False On Error GoTo ReportIt End If Dim myPara As Paragraph Set rng = Selection.Range.Duplicate For Each myPara In rng.Paragraphs myText = myPara.Range.Text For i = 2 To Len(myText) - 3 myYearText = Mid(myText, i, 5) If InStr("abcdefghijkl", Right(myYearText, 1)) = 0 Then _ myYearText = Left(myYearText, 4) myYear = Val(myYearText) If myYear > 1000 And Left(myYearText, 1) <> " " Then myPara.Range.InsertBefore Text:="]" & myYearText & "[" Exit For End If DoEvents Next i DoEvents Next myPara Selection.Sort With Selection.Find .ClearFormatting .Replacement.ClearFormatting .Text = "\][0-9a-h]@\[" .Wrap = wdFindStop .Forward = True .Replacement.Text = "" .MatchWildcards = True .Execute Replace:=wdReplaceAll DoEvents End With Application.ScreenUpdating = True Exit Sub End If ' Main citation listing section Beep myResponse = MsgBox("Is the cursor placed in the first item" _ & CR2 & "of the references list?", vbQuestion _ + vbYesNoCancel, "CitationAlyse") If myResponse <> vbYes Then Exit Sub On Error GoTo ReportIt Application.ScreenUpdating = False ' copy references right to the end Selection.Expand wdParagraph Selection.Collapse wdCollapseStart startRefs = Selection.Start Set rngOld = ActiveDocument.Content rngOld.Start = startRefs rngOld.Copy rngOld.Collapse wdCollapseStart rngOld.Start = 0 ' create new file of the text (not refs) + notes Set mainDoc = ActiveDocument Documents.Add Selection.Text = rngOld.Text ' Copy footnotes and endnotes, text only gotFoots = (mainDoc.Footnotes.Count > 0) gotEnds = (mainDoc.Endnotes.Count > 0) DoEvents If gotFoots = True And includeNotes = True Then Selection.EndKey Unit:=wdStory Selection.TypeText Text:=vbCr Selection.Text = mainDoc.StoryRanges(wdFootnotesStory).Text End If If gotEnds = True And includeNotes = True Then Selection.EndKey Unit:=wdStory Selection.TypeText Text:=vbCr Selection.Text = mainDoc.StoryRanges(wdEndnotesStory).Text End If DoEvents Set rng = ActiveDocument.Content With rng.Find .ClearFormatting .Replacement.ClearFormatting .Text = ",([0-9]{4})" .Wrap = wdFindStop .Replacement.Text = ", \1" .Forward = True .MatchWildcards = True .MatchWholeWord = False .Execute Replace:=wdReplaceAll End With With rng.Find .ClearFormatting .Replacement.ClearFormatting .Text = "[a-z] \([A-Z]" .Wrap = wdFindStop .Replacement.Text = "" .Forward = True .MatchWildcards = True .MatchWholeWord = False .Execute End With Do While rng.Find.Found = True endNow = rng.End rng.MoveStart wdWord, -1 rng.MoveEnd wdCharacter, -1 ' rng.Select rng.Text = LCase(rng.Text) rng.MoveStart wdWord, -1 ' rng.Select myMidWord = Left(rng, 3) If myMidWord = "und" Or myMidWord = "and" Then rng.MoveStart wdWord, -1 rng.Text = LCase(rng.Text) End If ' rng.Select rng.Start = endNow + 2 rng.End = endNow + 2 rng.Find.Execute DoEvents Loop ' Find and replace to create easy-to-search text myList = "#ü|uu#û|qcq#~<([A-Z]{2}).|\1# in press| 2999#/| #" & _ "~<([A-Z]).|\1#(| #)| #:| #;| #, | #" & _ "~<([A-Z])> ([A-Z])|\1ü\2#~<([A-Z]{2})> ([A-Z])|\1ü\2#" & _ "#.|ü#(|ü#)|ü#[|ü#]|ü#" & _ " et alii|üetüal# et al|üetüal# & |üandü# und |üandü#-|û#" & _ "~ ChrW(124) And _ InStr(myFR, ChrW(124)) > 0 Then If Left(myFR, 1) = "~" Then myWild = True myFR = Mid(myFR, 2) Else myWild = False End If barpos = InStr(myFR, ChrW(124)) myFind = Left(myFR, barpos - 1) myRep = Mid(myFR, barpos + 1) With rng.Find .ClearFormatting .Replacement.ClearFormatting .Text = myFind .Wrap = wdFindContinue .Forward = True .Replacement.Text = myRep .Replacement.Highlight = True .MatchWildcards = myWild .Execute Replace:=wdReplaceAll End With DoEvents End If Next i Set rng = ActiveDocument.Content With rng.Find .ClearFormatting .Replacement.ClearFormatting .Text = "<[12][0-9]{3}[!0-9]" .Wrap = wdFindStop .Replacement.Text = "" .Forward = True .MatchWildcards = True .Execute End With ' Find & Do to find all years Do While rng.Find.Found = True myEnd = rng.End myYear = Replace(rng, "ü", "") myYear = Replace(myYear, ",", "") myYear = Replace(myYear, ";", "") myYear = Trim(myYear) rng.Collapse wdCollapseStart rng.MoveStart wdWord, -1 myInit = Left(rng, 1) Debug.Print rng If (UCase(myInit) <> myInit Or UCase(myInit) _ = LCase(myInit)) And Left(rng, 3) <> "and" Then GoTo getNext If Left(rng, 3) = "and" Then rng.Start = rng.Start + 4 wd1 = Trim(rng) rng.Collapse wdCollapseStart rng.MoveStart wdWord, -1 wd2 = Trim(rng) myInit = Left(wd2, 1) gotTwo = (UCase(myInit) = myInit) And _ (UCase(myInit) <> LCase(myInit)) ' Find surname one and add to citeList1 citeList1 = citeList1 & wd1 & " " & myYear & CR ' Find surname two and add to citeList2 If gotTwo Then citeList2 = citeList2 & wd2 & _ " " & wd1 & " " & myYear & CR ' Check if another date follows rng.Start = myEnd rng.End = myEnd Do rng.MoveEnd wdWord, 1 If Len(rng) < 4 Then rng.Collapse wdCollapseEnd rng.MoveEnd wdWord, 1 End If myYearNumber = Val(rng) If Val(rng) > 1000 Then myYear = Trim(rng) citeList1 = citeList1 & wd1 & " " & myYear & CR If gotTwo Then citeList2 = citeList2 & wd2 & _ " " & wd1 & " " & myYear & CR End If rng.MoveStart wdWord, 1 myEnd = rng.Start DoEvents Loop Until myYearNumber < 1000 getNext: rng.Start = myEnd rng.End = myEnd rng.Find.Execute Loop Set rng = ActiveDocument.Content rng.Delete Selection.TypeText Text:=citeList1 myEnd = ActiveDocument.Content.End Selection.TypeText Text:=citeList2 Set rng = ActiveDocument.Content rng.Start = myEnd ' rng.Font.Italic = True Set rng = ActiveDocument.Content rng.Font.Color = myFontColour ' Change by F&R û to -, ü to space, uu to ü, qcq to û myList = "#ü| #uu|ü#û|-#qcq|û# 2999| in press#" FandR = Split(myList, "#") Set rng = ActiveDocument.Content For i = 1 To UBound(FandR) myFR = FandR(i) If Left(myFR, 1) <> ChrW(124) And _ InStr(myFR, ChrW(124)) > 0 Then barpos = InStr(myFR, ChrW(124)) myFind = Left(myFR, barpos - 1) myRep = Mid(myFR, barpos + 1) With rng.Find .ClearFormatting .Replacement.ClearFormatting .Text = myFind .Wrap = wdFindContinue .Forward = True .Replacement.Text = myRep .MatchWildcards = False .Execute Replace:=wdReplaceAll End With DoEvents End If Next i Set rng = ActiveDocument.Content rng.Sort SortOrder:=wdSortOrderAscending, _ SortFieldType:=wdSortFieldAlphanumeric ' Remove duplicates numPars = ActiveDocument.Paragraphs.Count For j = numPars To 2 Step -1 Set rng1 = ActiveDocument.Paragraphs(j).Range Set rng2 = ActiveDocument.Paragraphs(j - 1).Range If rng1 = rng2 Then rng1.Delete DoEvents Next j ' Highlight multiple part citations numPars = ActiveDocument.Paragraphs.Count Set rng = ActiveDocument.Content allText = rng myStrike = False For i = 1 To numPars myText = ActiveDocument.Paragraphs(i).Range.Text numTimes = Len(Replace(allText, myText, myText & "!")) - Len(allText) If numTimes > 1 And Len(myText) > 2 Then addCol = Int(5 * Rnd()) baseCol = Int(5 * Rnd()) Set rng = ActiveDocument.Content With rng.Find .ClearFormatting .Replacement.ClearFormatting .Text = Replace(myText, vbCr, "") .Wrap = wdFindStop .Replacement.Text = "" .MatchWildcards = False .Execute DoEvents End With Do While rng.Find.Found rng.HighlightColorIndex = myCol(baseCol) For j = 1 To rng.Characters.Count If (j Mod 5) < 2 Then rng.Characters(j).HighlightColorIndex = myCol(addCol) End If Next j DoEvents rng.Collapse wdCollapseEnd rng.Find.Execute Loop End If DoEvents Next i Options.DefaultHighlightColorIndex = oldColour Selection.EndKey Unit:=wdStory Selection.TypeText Text:=vbCr wasEnd = Selection.End Selection.Paste Set rng = ActiveDocument.Content rng.Start = wasEnd rng.Fields.Unlink With rng.Find .ClearFormatting .Replacement.ClearFormatting .Text = "^p " .Wrap = wdFindStop .Forward = True .Replacement.Text = "^p" .MatchWildcards = False .Execute Replace:=wdReplaceAll DoEvents End With ' Add author name to "ditto" type references myPrevAuthor = "" For i = 1 To rng.Paragraphs.Count Set myRef = rng.Paragraphs(i).Range myWord = Trim(myRef.Words(1)) If Len(myRef.Text) > 1 And Len(myWord) = 1 Then myRef.Select myWord = myRef.Words(2) End If mySample = Left(myRef.Text, 2) If Len(myRef.Text) > 1 And LCase(mySample) = _ UCase(mySample) Then myRef.Words(1) = myPrevAuthor & " " Else myPrevAuthor = myWord End If DoEvents Next i Set rng = ActiveDocument.Content rng.Sort SortOrder:=wdSortOrderAscending, _ SortFieldType:=wdSortFieldAlphanumeric DoEvents Set rng = ActiveDocument.Content rng.InsertAfter Text:=CR2 Set rng = ActiveDocument.Content rng.ParagraphFormat.LineSpacingRule = wdLineSpaceSingle rng.ParagraphFormat.SpaceBefore = 12 With rng.Find .ClearFormatting .Replacement.ClearFormatting .Text = "<[12][0-9a-j]{3,4}>" .Wrap = wdFindContinue .Forward = True .Replacement.Text = "^&" .Replacement.Font.Color = myDateColour .MatchWildcards = True .Execute Replace:=wdReplaceAll DoEvents End With Selection.HomeKey Unit:=wdStory Selection.TypeText Text:="Citation Query List" ActiveDocument.Paragraphs(1).Range.Style = wdStyleHeading2 ' Remove blank lines at the top Set para2 = ActiveDocument.Paragraphs(2) Do While Len(para2.Range.Text) < 3 para2.Range.Delete Loop notNames = notNames & " " For i = ActiveDocument.Paragraphs.Count To 2 Step -1 Set rng = ActiveDocument.Paragraphs(i).Range If InStr(notNames, rng.Words(1).Text) > 0 Then _ rng.Words(1).Delete Next i ' Add year at beginning of line Set rng = ActiveDocument.Content For Each myPara In rng.Paragraphs myText = myPara.Range.Text For i = 2 To Len(myText) - 3 myYearText = Mid(myText, i, 5) If InStr("abcdefghijkl", Right(myYearText, 1)) = 0 Then _ myYearText = Left(myYearText, 4) myYear = Val(myYearText) If myYear > 1000 And Left(myYearText, 1) <> " " Then myPara.Range.InsertBefore Text:="]" & myYearText & "[" Exit For End If DoEvents Next i DoEvents Next myPara ' Sort If rng.Words(1) = "Citation " Then rng.Start = rng.Paragraphs(1).Range.End End If rng.Sort SortOrder:=wdSortOrderAscending, _ SortFieldType:=wdSortFieldAlphanumeric DoEvents If rng.End = ActiveDocument.Content.End Then _ rng.InsertAfter Text:=vbCr numPars = rng.Paragraphs.Count myStart = 5 If numPars < myStart Then myStart = numPars For i = myStart To 1 Step -1 Set rng2 = rng.Paragraphs(i).Range If Len(rng2.Text) < 2 Then rng2.Delete Next i ' Add blank line at year change Set rng = ActiveDocument.Content wasYear = "" For i = rng.Paragraphs.Count To 1 Step -1 myYear = Left(rng.Paragraphs(i).Range.Text, 5) If myYear <> wasYear Then _ rng.Paragraphs(i).Range.InsertAfter Text:=vbCr wasYear = myYear DoEvents Next i ' Remove the year markers myBar = "~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~" myBar = "^p" & myBar & myBar & "^p" Set rng = ActiveDocument.Content With rng.Find .ClearFormatting .Replacement.ClearFormatting .Text = "^p^p" .Wrap = wdFindContinue .Forward = True .Replacement.Text = myBar .Replacement.Highlight = False .Replacement.Font.Color = wdColorAutomatic .MatchWildcards = False .Execute Replace:=wdReplaceAll DoEvents .ClearFormatting .Replacement.ClearFormatting .Text = "\][0-9a-h]@\[" .Wrap = wdFindContinue .Forward = True .Replacement.Text = "" .MatchWildcards = True .Execute Replace:=wdReplaceAll DoEvents End With ActiveDocument.Paragraphs(2).Range.Text = "" Beep Application.ScreenUpdating = True Exit Sub ReportIt: Application.ScreenUpdating = True On Error GoTo 0 Resume End Sub