Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-24-2023, 11:25 AM
Bunnelope Bunnelope is offline Macro to identify and fix long sentences without commas Mac OS X Macro to identify and fix long sentences without commas Office 2021
Novice
Macro to identify and fix long sentences without commas
 
Join Date: Mar 2023
Posts: 5
Bunnelope is on a distinguished road
Default macro to identify long stretches of sentence without commas or periods

I am new to the forum, so I hope I am replying to the thread correctly.





My macro request is much simpler than that. I don't want it to make any grammar suggestions at all. I just want it to identify long stretches without commas or periods by highlighting them. The macro that I found can do the same thing, but only accounts for long sentences. I assume that is because it counts the number of words between periods. I want one that will count the number of words between either commas or periods.

My use for this is in prepping manuscripts for narration. If I can identify a long, run-on sentence ahead of time, I can look at it and figure out ahead of time where to breathe. I can then add a comma or another indicator manually to tell myself to breathe when I am recording the narration.
Reply With Quote
  #2  
Old 03-24-2023, 12:43 PM
Charles Kenyon Charles Kenyon is offline Macro to identify and fix long sentences without commas Windows 11 Macro to identify and fix long sentences without commas Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,464
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by Bunnelope View Post
***
My macro request is much simpler than that. I don't want it to make any grammar suggestions at all. I just want it to identify long stretches without commas or periods by highlighting them. The macro that I found can do the same thing, but only accounts for long sentences. I assume that is because it counts the number of words between periods. I want one that will count the number of words between either commas or periods.

My use for this is in prepping manuscripts for narration. If I can identify a long, run-on sentence ahead of time, I can look at it and figure out ahead of time where to breathe. I can then add a comma or another indicator manually to tell myself to breathe when I am recording the narration.
If I am now reading you correctly, what you want is a macro that checks text and if there is a sentence that is longer than 30 words, you want to check for the presence of a comma and then check to see

  1. if there is a portion of that sentence between the start of the sentence and the first comma,
  2. or between that comma and the next,
  3. or between the last comma and the period, is more than ? how many? words, you want that sentence marked so you can review it.
This, vba can do, but you need to determine how many words are allowed in a phrase before a breath. What is too long for a sentence? For a phrase?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to identify and fix long sentences without commas Macro to select multiple sentences that contain a specific word MauiTruss Word VBA 7 10-03-2018 03:46 PM
Macro to identify and fix long sentences without commas Macro to number sentences tjf816 Word VBA 10 03-29-2017 05:42 PM
A Widlcard or Macro to Properly Remove Spaces Between Commas? CrossReach Word 6 01-23-2017 04:28 AM
Macro to identify and fix long sentences without commas Need a Macro that Combines Every 5 sentences into a paragraph jgarland Word 22 01-11-2012 11:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:27 AM.


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