View Single Post
 
Old 02-28-2020, 03:20 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

There is no simple programming solution for this. Although VBA has a 'sentences' collection, that has no correlation with grammatical sentences. For example, consider the following:
Mr. Smith spent $1,234.56 at Dr. John's Grocery Store, to buy: 10.25kg of potatoes; 10kg of avocados; and 15.1kg of Mrs. Green's Mt. Pleasant macadamia nuts.
For you and me, that would count as one sentence; for VBA it counts as 5 sentences.

You might be able to use Greg Maxey's 'Sentence Deducer' Addin (Deduced Sentences) to help work out where grammatical sentences end. See also his code in: https://www.msofficeforums.com/97131-post14.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote