A
Allan P. London, CPA
Folks,
For some reason my VBA programs have suddenly stopped working properly? I
get a "code execution interrupted" error. If I select continue, execution
continues with no problem. If I select debug the highlighted "error" code
is always an END IF, NEXT or END SUB command? The code runs just fine on my
other computers.
Also, this is not new code, I have been using some of these workbooks for
years without trouble. And, I have the same problem with ALL my workbooks
that have VBA code. I tried rebuilding Excel and re-compiling the code and
using Code Cleaner to copy the code to a text file and back into the VBA
editor. Nothing sees to fix the problem.
One possibility is that I run both Office 2007 and Office 2003 on my
machine. But I have been running "parallel" for about a year with no
problems? This problem started a few days ago? Also, I get the same problem
in Excel 2007 workbooks.
I am afraid that if I reinstall Office 2003, then I will need to also
reinstall Office 2007. Is that the only way to fix the problem assuming the
VBA has some corruption problem?
Thanks for the help
Allan P. London, CPA
alondon (no spam)@alondon,com
For some reason my VBA programs have suddenly stopped working properly? I
get a "code execution interrupted" error. If I select continue, execution
continues with no problem. If I select debug the highlighted "error" code
is always an END IF, NEXT or END SUB command? The code runs just fine on my
other computers.
Also, this is not new code, I have been using some of these workbooks for
years without trouble. And, I have the same problem with ALL my workbooks
that have VBA code. I tried rebuilding Excel and re-compiling the code and
using Code Cleaner to copy the code to a text file and back into the VBA
editor. Nothing sees to fix the problem.
One possibility is that I run both Office 2007 and Office 2003 on my
machine. But I have been running "parallel" for about a year with no
problems? This problem started a few days ago? Also, I get the same problem
in Excel 2007 workbooks.
I am afraid that if I reinstall Office 2003, then I will need to also
reinstall Office 2007. Is that the only way to fix the problem assuming the
VBA has some corruption problem?
Thanks for the help
Allan P. London, CPA
alondon (no spam)@alondon,com