Hi Guessed
Here are the results of running the macro 5 times on a document of 500 pages:
Speedtest macro:
1) 216 seconds
2) 670 seconds
3) 572 seconds
4) 285 seconds
5) 458 seconds
Average: 440 seconds
Previous macro:
1) 799 seconds
2) 498 seconds
3) 629 seconds
4) 525 seconds
5) 500 seconds
Average: 590 seconds
So your latest code is definitely faster, but there's still a huge amount of variation in process time going on.
Interesting what you mentioned about dimensioning as well - I always thought that putting the 2 variants in the same line:
Dim shapecount, shapemax As Long
...would dim both as Long, so I've learned something new there.
By the way, I don't do these jobs every day, but when I do I often have 10 or more docs of 1000 pages each to do, so it's definitely worth me trying to shave as much time off the process as possible.
|