Alien abduction of VB: "Code execution has been interrupted..."

[Paul B.]

I have literally hundreds of VB macros that have run flawlessly for years.
Suddenly this message started to appear everywhere. I found discussions of
the problem in various on-line forums, which report that the problem is not
just in Excel, but in Word and Access macros as well. So clearly this
phenomenon is a widespread malady. Something is going terribly wrong with VB.

My company's IT support staff gave me a brand new PC because of this
problem. Within an hour the problem appeared on the new PC, so clearly it was
ported over with my Excel workbooks.

I've read of workarounds like Application.EnableCancelKey=xlDisabled and
code cleaners (which don't much help in my case). I've also read various
theories regarding the cause. None of them sound credible up to now because
they imply that this is an isolated, local issue and I know that it's all
over the VB community.

On top of the code execution message, I'm finding that heretofore reliable,
bulletproof macros are occasionally generating spurious results.

Clearly something happend recently to a large number of VB users that make
their program execution environment unhstable. Is it a virus? Is it a
Microsoft patch to XP?

Something is not right. Please help.

Paul B.

 

[Mike H]

Hi,

One suggestion that has been known to work for this is to put this line at
the start of your code

Application.EnableCancelKey = xlDisabled


Mike

 

[Keithlo]

I would however take note of this snippet from VBA Help on topic
EnableCancelKey Property:
"Remarks
Use this property very carefully. If you use xlDisabled, there's no way to
interrupt a runaway loop or other non – self-terminating code. Likewise, if
you use xlErrorHandler but your error handler always returns using the Resume
statement, there's no way to stop runaway code."

I'm thinking you'd have to kill Excel via Task Manager in the cases described.

Keith

 

[gregr96]

Hi Paul

Had the same issue with some code I'd written. Turned out that they had
installed a web component for office 2003
(http://www.microsoft.com/downloads/...2C-402E-4F72-97A5-E0FD290D4B76&displaylang=en).
Had a look at the activex component on the net and found there was a SP1 for
it
(http://www.microsoft.com/downloads/...FA-D5F3-4B71-BF46-13721BD44682&displaylang=en). Installed that and all was good.

Greg