![]() |
|
#1
|
||||
|
||||
![]() It doesn't work because the syntax is wrong. e.g. you have declared regExp but called regEX. The following version should work Code:
Sub Acronyms() Dim dict, k, tmp Dim regExp, Match, Matches Dim rngRange As Range Set regExp = CreateObject("vbscript.regexp") Set dict = CreateObject("scripting.dictionary") regExp.Pattern = "[A-Z]{2,}" '2 or more upper-case letters regExp.IgnoreCase = False regExp.Global = True Set Matches = regExp.Execute(ActiveDocument.Range.Text) For Each Match In Matches tmp = Match.value If Not dict.Exists(tmp) Then dict.Add tmp, 0 dict(tmp) = dict(tmp) + 1 Next For Each k In dict.Keys Debug.Print k, dict(k) Next k End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
mars1886 | Word VBA | 15 | 03-30-2022 06:56 AM |
Synonym Finder | subrota | Word VBA | 3 | 04-29-2019 12:13 AM |
Using a product key finder to transfer MS from PC to Mac - risky? | loza890 | Office | 1 | 11-02-2014 10:43 PM |
![]() |
Cray_Z | Word VBA | 14 | 09-22-2014 11:42 PM |
Function Finder | Kevin18014 | Excel | 3 | 01-02-2012 04:47 PM |