I have an extensive VBA Addin that I have migrated through at least 3
generations of EXCEL. On two differentl occasions recently I have tried to
make a fairly stright forward change to the code. On both occassions I have
been stumped by generating an error

"EXCEL.EXE has generated errors and will be closed by windows"

When I trace where the error is occuring it is in code that is unrelated to
the changes I am making and has previously worked fine.

when I move the code around and retype it the errors still occur.

It seems as if there is corruption in the file underneath the code.

Has anyone experienced this. Is there some way to clean up a VBA file?

try running Rob Bovey's free code cleaner utility

http://www.appspro.com

I suspect you will need to make the Addin a workbook before you run it.

It essentially exports all your modules and forms, close and saves the
workbook, then imports them back in.

Obviously a backup copy should be made before starting (although I
suspect/expect the addin creates one as well).

--
Regards,
Tom Ogilvy

"Jim" wrote in message
...
I have an extensive VBA Addin that I have migrated through at least 3
generations of EXCEL. On two differentl occasions recently I have tried
to
make a fairly stright forward change to the code. On both occassions I
have
been stumped by generating an error

"EXCEL.EXE has generated errors and will be closed by windows"

When I trace where the error is occuring it is in code that is unrelated
to
the changes I am making and has previously worked fine.

when I move the code around and retype it the errors still occur.

It seems as if there is corruption in the file underneath the code.

Has anyone experienced this. Is there some way to clean up a VBA file?

I just tried Rob Bovey's code cleaner and I still have the
same problem.
-----Original Message-----
I have an extensive VBA Addin that I have migrated
through at least 3
generations of EXCEL. On two differentl occasions
recently I have tried to
make a fairly stright forward change to the code. On
both occassions I have
been stumped by generating an error

"EXCEL.EXE has generated errors and will be closed by
windows"

When I trace where the error is occuring it is in code
that is unrelated to
the changes I am making and has previously worked fine.

when I move the code around and retype it the errors
still occur.

It seems as if there is corruption in the file underneath
the code.

Has anyone experienced this. Is there some way to clean
up a VBA file?
.