I have one workbook with VBA code that consistently results in screen corruption.
This WB has routines that read data every minute from another workbook loaded into the same instance of Excel. My code uses an Excel timer to trigger these tasks. After reading the data from the other wb, some data analysis is done and the results written to both a cumulative array and to a worksheet in the wb with the timer. The routines run every day from 7:30AM to 4:15PM.
I have been running these routines in Excel 2003 for 2 years with no problems. Now, about 1.5 hrs after starting the workbook every morning, I spontaneously get disabling screen corruption in this workbook only. Control buttons disappear, although their tips will appear if I put the cursor over the spot where the control (such as minimize, close, maximize) should be. The ribbons also become unusable. The interesting thing is that the code is still running as it should in the background although I cannot see the results of what it’s doing. If I try to Save the workbook after corruption appears I get an ominous message box saying “Catostrophic Failure.” I can get rid of this box but nothing changes. The save I did goes through despite the message.
I’ve tried many things to fix the problem. I’ve made sure that all my drivers are the latest, particularly the video driver. I’m running:
Win xP SP2 and all updates
NVidia GeForce 7900 video card, with 256 kb video memory
Core2 Duo system with 4GB memory
Plenty of disk space.
I’ve tried turning off write-combining for my video card and it made no difference. Nothing makes any difference. The screen corruption always happens with this particular workbook and its routines.
Any suggestions or thoughts?
Appreciate any help.
6rtury
