Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #17  
Old 02-16-2016, 05:39 AM
jpl jpl is offline VBA and shapes very slow Windows 7 64bit VBA and shapes very slow Office 2010 32bit
Advanced Beginner
VBA and shapes very slow
 
Join Date: Jan 2016
Location: France
Posts: 33
jpl is on a distinguished road
Default

Hello

Here are the results I obtain for diverse versions of the macro:

Original macro (post # 1), modified to draw 500 rectangles: 108 seconds.
Macro modified by macropod (post # 17): 90 seconds
Macro (post # 5): 3 seconds.

I modified the macro of the message 17 in the following way:

Code:
...
    With DocTmp
      .Windows(1).Visible = False
      For i = 1 To 500
    ...
The macro runs in 5 seconds.

With Word 2003, the original macro runs in 1 second. Moreover, the original macro, adapted for Excel, runs in 0 seconds with Excel 2010!

There is apparently a problem of Shape objects handling in word 2010. It is surprising that nobody speaks about it on the Internet.

Thank you for your help.

Bonjour
Voici les résultats que j'obtiens pour diverses versions de la macro :
macro originale (message 1), modifiée pour dessiner 500 rectangles : 108 secondes
macro modifiée par macropod (message 17) : 90 secondes
macro (message 5) : 3 secondes.
J'ai modifié la macro du message 17 de la façon suivante :

La macro s'exécute en 5 secondes.
Avec Word 2003, la macro originale prend 1 seconde. Par ailleurs, la macro originale, adaptée pour Excel, s'exécute en 0 seconde avec Excel 2010 !
Il y a visiblement un problème de maniement des objets Shape en Word 2010. Il est surprenant que personne n'en parle sur Internet.
Merci pour votre aide
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 06:23 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