VBA File in EXCEL 2000 Crashes in code that I have made no changes

J

Jim

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?
 
T

Tom Ogilvy

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).
 
Top