While i was working on the macro (please see my previous complaint post), somehow, i managed to corrupt the file sooo bad, that i couldn't even open it (even on my Dad's laptop's Office 2003, when i tried to use the recovery options, it gave me this message: "Your file's damage was so extensive the Microsoft Excel cannot repair it."

DIE lor~

I spent the next 2 hours searching the net for solutions, downloaded some demo software which "supposedly" can recover files (but i need to buy that software to unlock the feature), opened-closed-reopened, anything.

To no avail....

I was preparing for the fact that today i would be bring a defect file back to office, when a light shone down on me....

If Microsoft Excel can't open... maybe OpenOffice could??

With this little ray of hope, i downloaded and installed OpenOffce (All Hail Open-Source! Free stuff for everyone!). Opened Calc (OpenOffice's version of Excel), and lo and behold! It opened! But alas, it doesn't seem to be able to restore the macro (the data means nothing to me, its the macro codes that's the whole BEING of the file). Nothing i tried seem to be working..

Alas....dooom is on me.

Then, a little angelic voice from the back of my sleep-deprived mine called out:

"Why don't you just re-save it as XLS format?"

Which i did..



And lo and behold!

THE MACRO's BACK!!!!

With what's left in me i did a few tests, just to make sure.... and yes! I got them back!

Now, today, in the office, with my sleep-deprived brain and my over-sized swollen eyes, I give thanks to thee, o' Open Office!

0 comments