Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
XL2003 toolbar macros in XL2007 | Excel Programming | |||
XL2007 Pivot Table causes code to run slow? | Excel Programming | |||
Macros involving SOLVER... function | Excel Discussion (Misc queries) | |||
Slow Macros ...3 | Excel Programming | |||
MACROs involving scrollbars | Excel Programming |