Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-04-2018, 02:12 PM
macropod's Avatar
macropod macropod is offline Sentence word count Windows 7 64bit Sentence word count Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,381
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


Before your code will have a chance of running, you'll need to replace all those 'smart' single quotes and double quotes with straight quotes. Even then, however, you should be aware that VBA has no idea what a grammatical sentence is. For example, consider the following:
Quote:
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 09-05-2018, 03:47 AM
Nanaia Nanaia is offline Sentence word count Windows 7 64bit Sentence word count Office 2016
Novice
Sentence word count
 
Join Date: Dec 2016
Location: Lexington, KY
Posts: 10
Nanaia is on a distinguished road
Default

Macropod/Paul,
Thank you for the information. I have no issues with a macro thinking your example is 5 sentences. I understand that it doesn't know the difference between a period at the end of a sentence and one used in a title such as mister (Mr.) or a dollar value and I'm okay with that.
When I try to change the 'smart' single quotes (') with straight quotes (") I get the following error

Compile error:
Expected: line number or label or statement or end of statement

with an OK and a HELP button. when I select the HELP button it opens a web browser page. I've attached a screen shot. If there are recommendations for a different macro I am open to new ideas.
Thank you.
Attached Files
File Type: zip Untitled.zip (518.7 KB, 18 views)
Reply With Quote
Reply

Tags
vba code



Similar Threads
Thread Thread Starter Forum Replies Last Post
Sentence word count Split sentence at bold word jeffreybrown Word 2 08-17-2018 07:09 PM
Sentence word count How to count alphabets in a sentence? Awesomeg Word 2 03-09-2018 09:37 PM
Sentence word count Delete does not bring second sentence closer to first sentence Andoheb Word 29 07-03-2014 01:48 PM
Sentence word count First word of sentence IF and then awolf Word VBA 7 03-16-2014 02:40 PM
I want to lock a sentence in Word smorkette Word 1 02-06-2010 12:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:10 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft