I have coauthored an Excel file with many macros. After I use it a while, it
crashes in random places with "Microsoft Office Excel has encountered a
problem and needs to close..." The error signatures are in vbe6.dll.

The problem seems to be cumulative and associated with running macros.
Indeed, I can temporarily fix the problem by opening the file with macros
disabled, saving it, and reopening with macros enabled. However, it keeps
getting less and less stable the longer it is used, so it appears to be some
kind of accumulating corruption. Eventually, I have to create a new workbook
and manually copy all of the macros over to the new workbook, etc., which
works for a while. Many of my users are experiencing the same phenomenon.

Has anyone else experienced this kind of random corruption associated with
macros? The file is available for public downloading at
www.japaneselearningtool.com.

Sorry, typo. URL is www.japaneselearningtools.com

You may have problems getting anyone to download and use
a file that is corrupted and crashes your computer.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"mps"
wrote in message
Sorry, typo. URL is www.japaneselearningtools.com

It doesn't crash the computer. Excel sometimes crashes when running its
macros. What are you suggesting the risk is?

"Jim Cone" wrote:

You may have problems getting anyone to download and use
a file that is corrupted and crashes your computer.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"mps"
wrote in message
Sorry, typo. URL is www.japaneselearningtools.com

I had a quick look, but with all those forms, WS, modules and classes, I
don't have to check it all.
If you can be more specific, I'll have another look.

You do have a couple of problems :
- "Rebuild All Kanji" menu routine, as I get only 2 rows of characters, with
all rows' height set 254 pixels. Excel XP.
- use the "Kanji Info" menu routine then results in a "Subscript out of
range" error. "Start Test" also errors
- "Start nonaffect Text" menu routine errors with
........NonAffectingTextButton_Click cannot be found

NickHK

"mps" wrote in message
...
It doesn't crash the computer. Excel sometimes crashes when running its
macros. What are you suggesting the risk is?

"Jim Cone" wrote:

You may have problems getting anyone to download and use
a file that is corrupted and crashes your computer.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"mps"
wrote in message
Sorry, typo. URL is www.japaneselearningtools.com

Hi Nick,
Don't worry about "Rebuild All Kanji" and "Start non-affecting tests". Those
deprecated commands have mundane VBA errors.

I put up a particularly unstable version at
http://www.japaneselearningtools.com/crash.zip. This crashes Excel for me
just by opening the file (with macros enabled) and pressing the save button.
On different machines, it fails differently at different times, but if you
try saving, using "Show Kanji Info" and run a test via "Start Test" (just
enter any text if you don't know Japanese), it will probably crash Excel
pretty soon (not just give a VBA error).

Thanks for looking at this,

Mike

PS. I apologize if this is a double post, but my previous post command
failed, so I don't know if this will be a duplicate.

"NickHK" wrote:

I had a quick look, but with all those forms, WS, modules and classes, I
don't have to check it all.
If you can be more specific, I'll have another look.

You do have a couple of problems :
- "Rebuild All Kanji" menu routine, as I get only 2 rows of characters, with
all rows' height set 254 pixels. Excel XP.
- use the "Kanji Info" menu routine then results in a "Subscript out of
range" error. "Start Test" also errors
- "Start nonaffect Text" menu routine errors with
........NonAffectingTextButton_Click cannot be found

NickHK

"mps" wrote in message
...
It doesn't crash the computer. Excel sometimes crashes when running its
macros. What are you suggesting the risk is?

"Jim Cone" wrote:

You may have problems getting anyone to download and use
a file that is corrupted and crashes your computer.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"mps"
wrote in message
Sorry, typo. URL is www.japaneselearningtools.com