Short loop takes no less than 12s to run, uses 25% CPU power!

alex100 · #6 10-18-2020, 03:58 AM

Andrew, Paul, thank you both very much!

I tested your solutions, and in my case, the only one that did improve the execution time was Paul's first loop.

So, for the sake of clarity, here's the code I was using...

Code:

Dim iRev As Long
For iRev = ActiveDocument.Range.Revisions.Count To 1 Step -1
    With ActiveDocument.Range.Revisions(iRev)
        With ActiveDocument.Range.Revisions(iRev)
            Select Case .Type
                Case wdRevisionDelete, wdRevisionCellDeletion
                '
                ' more code here...
                '
                .Reject
            End Select
        End With
    End With
Next iRev

Execution time: 12 seconds

And now, with a major speed improvement (thanks to Paul's code!), I'm using this...

Code:

Dim iRev As Revision
With ActiveDocument.Range
    For Each iRev In .Revisions
        With iRev
            Select Case .Type
                Case wdRevisionDelete, wdRevisionCellDeletion
                '
                ' more code here...
                '
                .Reject
            End Select
        End With
    Next
End With

Execution time: 1 second

Apart from the huge difference in execution time, there are no other differences in the end result.

Alex

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can i open a power point in design mode through a power point shoe	noora	PowerPoint	4	12-10-2019 12:18 AM
Google Docs Power Point Short cuts / Insert Image etc	Rado	PowerPoint	4	04-11-2014 03:50 AM
video loop lag in power point 2013	drwrath	PowerPoint	2	04-29-2013 05:53 PM
Microsoft Power Point 2004 to Office Power Point 2007	chuff	PowerPoint	0	03-20-2011 01:23 PM
mail merge takes and age	williebear	Outlook	1	05-27-2009 11:32 PM