Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 06-21-2017, 10:50 PM
gmayor's Avatar
gmayor gmayor is offline Ugraded to Word 2013 Macro not performing Windows 10 Ugraded to Word 2013 Macro not performing Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Using your test document, which is far more complex than I had anticipated, the process is indeed much slower than in Word 2010 and even in 2010, your test document took rather longer than 8 seconds, however while my PC may have a lot of memory and a very fast drive, it does not have a particularly fast processor.

As you are processing a lot of paragraphs sequentially, there is not a lot you can do to speed that process.

If you can eliminate many (or all) of the unwanted paragraphs using the replace function then the process would have less to do and thus be faster. 'Replace' is infinitely faster than the paragraph looping.

e.g. a wildcard search for
\! \! \!*^13
replace with nothing will remove a lot of unwanted paragraphs very quickly and the processing time of your macro was then reduced to a third.

You should be able to remove many of the others similarly, but as the document is a mock up without real values, it is difficult to suggest the wildcard strings required, however see http://www.gmayor.com/replace_using_wildcards.htm
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2013 two laptops near identical spec performing differently mobile Excel 6 04-04-2016 03:39 AM
Ugraded to Word 2013 Macro not performing Copy macro/template from Word 2013 to 365 saclucas Word VBA 1 02-18-2016 09:19 PM
Ugraded to Word 2013 Macro not performing Word 2013: Hotkey to call a macro arjfca Word 2 12-04-2014 12:53 AM
Ugraded to Word 2013 Macro not performing Macro not Performing Formula Update as Expected tandchas Excel Programming 7 06-27-2014 05:42 AM
Ugraded to Word 2013 Macro not performing Question about macro in word 2013 tombags Word 1 06-25-2014 04:56 PM

Other Forums: Access Forums

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