Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #12  
Old 02-14-2016, 03:26 PM
macropod's Avatar
macropod macropod is offline VBA and shapes very slow Windows 7 64bit VBA and shapes very slow Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

Previously, when I ran the test, I simply copied the code into a new document (docx format) and ran it. Time to execute: 0 seconds

I've now saved the document in the docm format, then closed, re-opened the document and re-run the macro from post #5. Time to execute: 2.0 seconds on first run, 11.0 seconds on the second run if I don't clear the output from the first run, 2.0-3.0 seconds otherwise.

Curiously, if I change the two references to:
ActiveDocument.Windows(1).Visible
to:
Application.ScreenUpdating
Time to execute: 70 seconds!

All runs in Print Layout view.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA and shapes very slow shapes in header mhagi Word VBA 2 10-16-2015 12:21 AM
VBA and shapes very slow Slow internet = Slow Word... User12344321 Word 4 09-21-2015 12:54 PM
All Shapes on slide excelledsoftware PowerPoint 9 09-15-2013 04:03 AM
VBA and shapes very slow Where did map shapes go? SueK PowerPoint 1 01-20-2011 04:30 AM
My Shapes some appear some don't Jean-Paul Visio 0 03-01-2006 01:38 AM

Other Forums: Access Forums

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