Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-20-2017, 03:17 PM
Tye30 Tye30 is offline Ugraded to Word 2013 Macro not performing Windows 7 32bit Ugraded to Word 2013 Macro not performing Office 2010 32bit
Novice
Ugraded to Word 2013 Macro not performing
 
Join Date: Apr 2017
Posts: 7
Tye30 is on a distinguished road
Default Ugraded to Word 2013 Macro not performing


Upgraded to Word 2013 from Word 2010 and the time to execute this macro went form 8 seconds to 208 seconds. When I run the code with not using
Code:
Application.ScreenUpdating = False
it actually runs faster at 191 seconds. Is there a setting I need to adjust or is this some kind of bug?

I am a beginner in VBA and I got this code from online

Code:
 
Dim StartTime As Double
Dim SecondsElapsed As Double
  StartTime = Timer
 
    Application.ScreenUpdating = False
 
    Dim oPara As Paragraph
    For Each oPara In ActiveDocument.Paragraphs
        If InStr(1, oPara.Range.Text, "!Z! !") = 0 Then
            oPara.Range.Delete
        End If
    Next
 
    With ActiveDocument.Range.Find
        .Replacement.ClearFormatting
        .Text = "!"
        .Replacement.Text = "|"
        .MatchWildcards = False
        .Execute Replace:=wdReplaceAll, Forward:=True, Wrap:=wdFindContinue
    End With
 
    Application.ScreenUpdating = True
 
  SecondsElapsed = Round(Timer - StartTime, 2)
  MsgBox "This code ran successfully in " & SecondsElapsed & " seconds", vbInformation
Attached Files
File Type: docx Test_Format.docx (175.1 KB, 28 views)

Last edited by Tye30; 06-21-2017 at 06:25 AM. Reason: Add attachment
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 12:54 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