Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-06-2017, 05:33 PM
Thefirstfish` Thefirstfish` is offline Infinite loops occurring in find and replace functions in word macro Windows 10 Infinite loops occurring in find and replace functions in word macro Office 2016
Novice
Infinite loops occurring in find and replace functions in word macro
 
Join Date: Dec 2015
Posts: 11
Thefirstfish` is on a distinguished road
Default

Thanks so much. The code you posted and some minor tweaks have solved most of the issues I've been having.

For some reason, having tracked changes on makes the above code behave oddly in some situations (e.g., one function changes "1+1" to "1 + 1" with tracked changes off, but with tracked changes on the output is "11+ ").

However, I can work around that by running the macro with tracked changes off then comparing documents to add the tracking.

The only thing I still can't automate is to remove the percentage sign in text such as "20%-40% when an en dash is used instead of a hyphen. However, I have about 150 functions in the macro so having only one misbehaving isn't bad.
Reply With Quote
  #2  
Old 04-06-2017, 07:18 PM
macropod's Avatar
macropod macropod is offline Infinite loops occurring in find and replace functions in word macro Windows 7 64bit Infinite loops occurring in find and replace functions in word macro Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,512
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

Quote:
Originally Posted by Thefirstfish` View Post
For some reason, having tracked changes on makes the above code behave oddly in some situations (e.g., one function changes "1+1" to "1 + 1" with tracked changes off, but with tracked changes on the output is "11+ ").
Yes, that's a known 'Track Changes' behaviour. You could have the macro toggle & restore the 'Track Changes' state.
Quote:
Originally Posted by Thefirstfish` View Post
The only thing I still can't automate is to remove the percentage sign in text such as "20%-40% when an en dash is used instead of a hyphen. However, I have about 150 functions in the macro so having only one misbehaving isn't bad.
That's easily resolved by changing
.Text = "([0-9])%(-[0-9])"
to:
.Text = "([0-9])%(?[0-9])"
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Infinite loops occurring in find and replace functions in word macro Need Macro for Find and Replace, Inserting logo in Ms-Word. Aswinraj Word VBA 1 06-05-2016 04:33 PM
Find and Replace Macro Need djpemberton Word VBA 2 05-04-2016 07:53 PM
Infinite loops occurring in find and replace functions in word macro Find and Replace Macro amparete13 PowerPoint 3 03-11-2014 05:29 AM
Infinite loops occurring in find and replace functions in word macro Word VBA Macro to Find and Replace based on the Alt Text of an Image bennymc Word VBA 1 01-27-2014 04:23 PM
Find and Replace Macro - A Better Way Tribos Word VBA 0 10-08-2008 03:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:21 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