Excel crash when running macro

[Eamonn]

Hi, I keep getting a crash in Excel when I try running some macros I
have, the basic format is find something in one sheet, try and find in
another workbook (so open a file), if not there, replace. Obviously
there is a good deal more complexity than that, but that is the
general idea.

I keep getting the following:

The instruction at '0x308e0b79' referenced memory at '0x03add000'. The
memory could not be read.

Is this a problem with my code, or Excel, I found a few things that it
might have been and changed those but still experiencing the problem.

Any ideas. Thanks

Eamonn

 

[Anonymous]

Just curious if you ever found the problem. I'm having the same
problem upon shutting down Excel programmatically (not same memory
address though).

 

[Eamonn]

Just curious if you ever found the problem. I'm having the same
problem upon shutting down Excel programmatically (not same memory
address though).

Hi, I think the problem is a combination of a couple of things, i
turned off screen updating, that helped a little bit, then some of the
sheets I was working with were trying to save as Excel 95 and 2000,
that is the main source of the problem I think. Apart from that I am
not doing anything different than before, I would say the save as
different versions is the problem.

 

[Anonymous]

OK, I'll try these - thanks!

Hi, I think the problem is a combination of a couple of things, i
turned off screen updating, that helped a little bit, then some of the
sheets I was working with were trying to save as Excel 95 and 2000,
that is the main source of the problem I think. Apart from that I am
not doing anything different than before, I would say the save as
different versions is the problem.

 

[Guest]

I have just started having a similar problem using Excel 2003 in Windows XP.
I am using the control toolbox to make list boxes which simply pull the list
from another spreadsheet and then send the pick result to a cell on that
sheet. It almost seems random, except it happens about every 10 minutes. I
did not notice this problem until I installed a recent service pack for MS
Office. I tried turning off calculation while I am editing the controls, but
that does not seem to help. This is frustrating because Excel wipes the file
clean of VBA code as it crashes Excel.