Error from losing power while writing macro. Recovery help?
 

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

Thank you

Error from losing power while writing macro. Recovery help?
 

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" wrote in message
...
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 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 "physically" damaged?

Thank you

Error from losing power while writing macro. Recovery help?
 

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" wrote in message
...
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 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 "physically" damaged?

Thank you