LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 747
Default xl2007 - Slow Macros Involving Graphics

BACKGROUND:

I developed an interactive Excel-based program for the engineering and
construction industries using xl2003. It is essentially a picture management
system. Developement time was roughly 100 hours. My latest project involves
exactly 840 pictures. I have been avoiding upgrading to xl2007 like the
plague.

PROBLEM:

The client has xl2007 and there were some compatibility issues. So I
installed the xl2007 trial version and fixed these issues. However, what I
can't fix is the extremely slow macro execution time. For example, I remapped
the arrow keys to move the pictures without having to select them first.
Using xl2003, holding down an arrow key caused the picture to *glide* in the
direction of the arrow key. In xl2007, the pictures move in slow, jerky
steps. Picture import and other macros take about 5 times as long to execute.

QUESTION:

I could only determine that MS is aware of the issue. Does anyone know if
and when this issue will be fixed? Or am I screwed?!

BTW, I am perfectly aware of screenupdating and LockWindowUpdate etc. These
have already been implemented.

Much appreciative of any information.

Greg Wilson

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XL2003 toolbar macros in XL2007 Paul Martin[_2_] Excel Programming 1 September 23rd 09 02:20 PM
XL2007 Pivot Table causes code to run slow? michael.beckinsale Excel Programming 3 November 3rd 08 01:13 PM
Macros involving SOLVER... function Pixies Excel Discussion (Misc queries) 5 April 20th 06 05:07 PM
Slow Macros ...3 Sanj Excel Programming 1 June 9th 04 02:38 PM
MACROs involving scrollbars HW[_2_] Excel Programming 1 November 20th 03 12:24 PM


All times are GMT +1. The time now is 10:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"