Recovering Code from corrupt file

Posted by Matt Maule on September 10, 2001 9:58 AM

I am only a half decent VBA programmer,
with bad housekeeping discipline in my projects.
I encountered an Excel-crashing message this morning
with page stacking faults given as the reason.

My question is: Is there a way of dragging my code
out of the corrupt file - I have tried the Excel
Recovery Program mentioned in this web site, but to
no avail

Even if your comments are "Forget it, Mate!" that will
be great, so I don't continue barking up that tree like
a rabid dog

Cheers, Matt

Posted by Damon Ostrander on September 10, 2001 4:13 PM

Hi Matt,

Most likely, the file is irretrievably lost. If you haven't already done so, you should try opening the file with macros disabled AND worksheet calculation set to Manual. If you don't get the macro enable message, your macro security is set to Low, and you should set it at least to medium so you can disable macros.

Damon