Code Execution Has Been Interruptred?

[alondon]

Folks,

I have a very large Excel sales forecast app that I developed that does a
lot of Pivot Table analysis - up to 30,000 records. So this app takes A LOT
of memory and computer resources.

If I use the program for several hours without re-booting the machine, I
start to get "Code Execution Has Been Interrupted - Debug Run Continue" just
after loading the various regional workbooks that contain the data. I load
the regional data sheets one at a time, grab the data, then close them
without saving under VBA contrrol. I can hit "Continue" and every thing
works fine for a while. But, the occurance of this error increases over
time. Finally, I will be forced to reboot to fix the problem. On Error
Resume Next does not solve the problem because evidently, this is not an
error.

I am running on a 756 MB of memory and 1.2 GH AMD on my desktop computer
with Office 2003 Professional (SP up to date) and XP Professional SP 2. I
know - maybe time for a new box.

What is going on here? I don't appear to be running out of memory - I
checked.

Al London, CPA
San Francisco, CA
http://alondon.com

 

[michael.beckinsale]

Al,

I had excactly the same problem a few days ago which occured after l
had purposely tried to interrupt the code. On re-running the code it
kept stopping after a few loops of the code. Re-booted and same problem
occured.

I eventually put it down to a 'sticky' keyboard key, so took apart /
cleaned up the keyboard and voila! all was OK.

Hope this helps

Regards

Michael Beckinsale

 

[ion]

There are a number of posts in this newsgroup about starting to get
"code execution has been interrupted" sporadically after ctrl+break,
which is sometimes cleared by a reboot.
I don't see a KB article on it. Does MS have any progress on this?