Code Execution has been Interrupted

J

JPutman

I would be suprised if this issue has not come up here
before, but I have not been able to find it in a Search
yet.

At seemingly random times (while running different parts
of my code) I am getting the 'Code execution has been
interrupted' dialog popup as though I have hit
Ctrl+Break... even though I have not. Sometimes it
happens and sometimes it does not... and sometimes it
happens over and over again (ad nauseum) during the same
macro run.

When I break into the code, it is always stopped on random
lines that I know work fine... and it seems to rarely stop
on the same lines twice.

When I tried to google this, I came across a handful of
others that were seeing this as well in other discussion
threads. There were never any answers found... most of
the users were convinced that it had something to do with
a line of code. I am completely convinced that this is
not the case due to the randomness of the event
happening.

This is not only happening within Excel, but occasionally
Outlook and Access as well. I have somewhat ignored the
issue, as it was not reported happening to my addin
clients... however an inside QA person recently started
having this happen to them as well. I need to find out
what is going on.

I had Office XP up until this week and now have upgraded
to Office 2003. It happened in both version, however it
never happened before XP.

Hopefully at least others have seen this behavior... even
if you don't have an answer, please post to let me know
that you are seeing it.

thanks!

-jputman
 
S

Shiva

I am having this same 'Code interrrupted' issue too since
yesterday....

I am wondering if it has something to do with the Bl00mberg software.
I say this because.
- Bl00mberg is the only software I installed before the error started
occurring.
- Another trader with Bl00mberg DDE add-in running in his excel had
same problems. He was using my add-in and used to ask me what it was.
We temporarily worked around it by click 'F5' or continue. Now it has
come back to bite me in the A...

Has anyone found any solutions yet ? I couldn't find answers in
google/deja either. Sorry...
 
S

Steve Hieb

Interesting. I've been working on an Excel application for months and
all the sudden started getting this error today for no reason.
Coincidentally I was listening to Bloomberg radio all day via Windows
Media Player, which I normally don't do. Seems like there must be
some kind of problem with Bloomberg, but I don't see how it could
affect XL. The code interruption seemed random and it even entered
break-mode when there was no break! Very strange.

As soon as I rebooted the problem disappeared. FYI, this was on NT
and XL97.
 
R

Rob Bovey

Hi Steve,

This is a very common sign that your VBA project has accumulated too
much junk in the background and needs to be cleaned. Download my code
cleaner from the web site below, run your project through it and see if that
fixes the problem.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
 
S

Steve Hieb

Rob,

I use your code cleaner routinely and it works great ... thanks. I
can't replicate the issue since my reboot, but I'm certain it has
nothing to do with accumulation of junk. The file was just cleaned
days ago and I don't think I changed any code. My guess is it was
somehow memory related since I hadn't rebooted in weeks. Excel was
doing some very unexpected things which makes me think memory,
corrupted file, etc. However, reading all the other posts about
issues programming with Bloomberg add-in makes me wonder if just
listening to their station could have somehow caused the issue.
Probably just a coincedence. No need to reply, everything works fine
now.

Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top