Error from losing power while writing macro. Recovery help?

[MSgtMark]

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 "Enable macros" message
and the "update links" 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 are:

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 "physically" damaged?

Thank you

[PCLIVE]

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 "OpenOffice" 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,
Paul


"MSgtMark" <MSgtMark@discussions.microsoft.com> wrote in message
news:F55DC7DB-EAEC-4538-BDF9-335FC99B57D0@microsoft.com...
> 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 "Enable macros" message
> and the "update links" 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 are:
>
> 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 "physically" damaged?
>
> Thank you

[MSgtMark]

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

"PCLIVE" wrote:

> 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 "OpenOffice" 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,
> Paul
>
>
> "MSgtMark" <MSgtMark@discussions.microsoft.com> wrote in message
> news:F55DC7DB-EAEC-4538-BDF9-335FC99B57D0@microsoft.com...
> > 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 "Enable macros" message
> > and the "update links" 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 are:
> >
> > 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 "physically" damaged?
> >
> > Thank you
>
>
>