software

Has anyone else run into the following problem?

I was in the midst of writing a macro when my laptop blew a gasket and died.
Once I was able to restart, I re-opened both the original and the recovered
spreadsheet. In both cases, I received the normal quot;Enable macrosquot; message
and the quot;update linksquot; message, but then I received the following error:

The instruction at “0x3005c59b” referenced memory at “0x00000018”. The
memory could not be “written”.

Which is about as informative as a mime with laryngitis...

My questions a

1. Is anyone familiar with this error and what to do about it?

2. If this spreadsheet is corrupted (physically lost things), what recovery
source code is there available (if any)?

3. Is there any source code available to examine a spreadsheet and
determine IF it's quot;physicallyquot; damaged?

Thank you

I experienced something similar where I had a bunch of macros in this one
file that somehow had gotten corrupted. I, like you, was able to get to the
Macro message. However, selecting Enable or Disable didn't matter. It
still crashed before being able to get into the file. It was suggested to
try a program called quot;OpenOfficequot; which can be downloaded from
www.OpenOffice.org
It's a hefty download, but it allowed me to open my corrupted Excel file
which allowed me to access my Macros and copy the code to another location.
My Excel file was in fact corrupt because the appearance of my worrksheets
was pretty messed up. However, my macros were intact. OpenOffice saved me
a lot of work. Otherwise, I would have had to write my macros all over
again.

HTH,
Paulquot;MSgtMarkquot; gt; wrote in message
...
gt; Has anyone else run into the following problem?
gt;
gt; I was in the midst of writing a macro when my laptop blew a gasket and
gt; died.
gt; Once I was able to restart, I re-opened both the original and the
gt; recovered
gt; spreadsheet. In both cases, I received the normal quot;Enable macrosquot; message
gt; and the quot;update linksquot; message, but then I received the following error:
gt;
gt; The instruction at quot;0x3005c59bquot; referenced memory at quot;0x00000018quot;. The
gt; memory could not be quot;writtenquot;.
gt;
gt; Which is about as informative as a mime with laryngitis...
gt;
gt; My questions a
gt;
gt; 1. Is anyone familiar with this error and what to do about it?
gt;
gt; 2. If this spreadsheet is corrupted (physically lost things), what
gt; recovery
gt; source code is there available (if any)?
gt;
gt; 3. Is there any source code available to examine a spreadsheet and
gt; determine IF it's quot;physicallyquot; damaged?
gt;
gt; Thank you
Paul,

Thank you! That worked beautifully to recover the macros. You saved a few
hours there and I appreciate it. I appreciate having a nice, new tool to add
to the toolbox as well. I can't wait to play with that. Looks interesting.

Thank you again,
Mark

quot;PCLIVEquot; wrote:

gt; I experienced something similar where I had a bunch of macros in this one
gt; file that somehow had gotten corrupted. I, like you, was able to get to the
gt; Macro message. However, selecting Enable or Disable didn't matter. It
gt; still crashed before being able to get into the file. It was suggested to
gt; try a program called quot;OpenOfficequot; which can be downloaded from
gt; www.OpenOffice.org
gt; It's a hefty download, but it allowed me to open my corrupted Excel file
gt; which allowed me to access my Macros and copy the code to another location.
gt; My Excel file was in fact corrupt because the appearance of my worrksheets
gt; was pretty messed up. However, my macros were intact. OpenOffice saved me
gt; a lot of work. Otherwise, I would have had to write my macros all over
gt; again.
gt;
gt; HTH,
gt; Paul
gt;
gt;
gt; quot;MSgtMarkquot; gt; wrote in message
gt; ...
gt; gt; Has anyone else run into the following problem?
gt; gt;
gt; gt; I was in the midst of writing a macro when my laptop blew a gasket and
gt; gt; died.
gt; gt; Once I was able to restart, I re-opened both the original and the
gt; gt; recovered
gt; gt; spreadsheet. In both cases, I received the normal quot;Enable macrosquot; message
gt; gt; and the quot;update linksquot; message, but then I received the following error:
gt; gt;
gt; gt; The instruction at quot;0x3005c59bquot; referenced memory at quot;0x00000018quot;. The
gt; gt; memory could not be quot;writtenquot;.
gt; gt;
gt; gt; Which is about as informative as a mime with laryngitis...
gt; gt;
gt; gt; My questions a
gt; gt;
gt; gt; 1. Is anyone familiar with this error and what to do about it?
gt; gt;
gt; gt; 2. If this spreadsheet is corrupted (physically lost things), what
gt; gt; recovery
gt; gt; source code is there available (if any)?
gt; gt;
gt; gt; 3. Is there any source code available to examine a spreadsheet and
gt; gt; determine IF it's quot;physicallyquot; damaged?
gt; gt;
gt; gt; Thank you
gt;
gt;
gt;