View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Wilson Greg Wilson is offline
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