Excel crash when running macro
 

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

Excel crash when running macro
 

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) wrote in message . com...
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

Excel crash when running macro
 

Excel crash when running macro
 

OK, I'll try these - thanks!




(Eamonn) wrote in message . com...
(Anonymous) wrote in message . com...
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.

Excel crash when running macro
 

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.

"Eamonn" wrote:

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