Impossible to open excel workbook

[Enk]

Hi everybody.
I have an enormous problem.
I've built an excel 2000 workbook with a lot of vba code, modules and userforms.
All of a sudden, one day, I tried to open it and NOTHING!!!!
A message appeared (and still appears each time I open the wb), saying something like this: "an error occurred on module......not valid page...." and so on.... (the message is not exactly like that because I translated it here in english as my excel version is not in english, but I hope you understood what message it is).
So: does anybody give me any suggestion about how to open or recover my file (or, at least, how to recover the vba modules and the userforms, which are the most important part of the wb).
Thank you all by now for your kind replies.
Bye
Nick

 

[Enk]

PHV thank you for replying.
If I could restore the backup I would have done it 17 posts ago .
I've no backup of that file. I know, it's my fault, but...
what can I do now?
Thanks
Nick

 

[stevexff]

Short of opening the file in Notepad and using what you find as a rather garbled aide memoire when you are re-writing your code, I can't suggest anything. Think positive, it's an opportunity to refactor

For the future, regular back-ups, or better still some kind of source control system is the way forward...

Steve

[small]"Every program can be reduced by one instruction, and every program has at least one bug. Therefore, any program can be reduced to one instruction which doesn't work." (Object:erlDesignPatterns)[/small]

 

[HorseGoose]

If you send the file to me I can try and look at it for you, two minds may be better than one in this case.

 

[Enk]

Thank you Steve.
I think that at last I'm going to buy one of those expensive softwares that fix this kind of problems.
Next time.... backup
Bye
Nick

 

[mscallisto]

Have you tried this?

http://support.microsoft.com/kb/820741

See the section "Use the "Open and Repair" command"

sam

 

[Enk]

Hi Sam, tanks for replying.
Yes, I've tried that, but all the methods included in that page assume that it's still possible to open the damaged file.
My problem is that my file is "Untouchable". I mean you cannot open it neither with macros enabled nor with macros disabled. As soon as the file is loaded by excel the message error appears.
Anyway, those methods (saving in sylk or htm or doc format) let you recover only data from the sheets, not from vba modules and userforms.
Unfortunately.
Thank you anyway
Bye
Nick

 

[stevexff]

Nick

OpenOffice

http://www.openoffice.org

can open Excel files. I think it attempts to convert macros to OOBasic with a wizard, but I read somewhere that it comments out the original code just in case the wizard doesn't work properly. This might allow you to recover the code.

As a last ditch attempt before forking out for a proprietary recovery method, it might be worth a try.

Just remember that when you install it, uncheck the file association boxes so it doesn't mess up your existing Office associations...

Steve

[small]"Every program can be reduced by one instruction, and every program has at least one bug. Therefore, any program can be reduced to one instruction which doesn't work." (Object:erlDesignPatterns)[/small]

 

[Enk]

Hi Steve.
Thanks for replying.
I'll try it as soon as possible and I'll let you know.
Thank you so much
Regards
Nick