Sorry for the loss, and good luck with the recovery—Chris' post links to some very useful tips, a couple of which I have used in the past to recover from just this situation.
Going forward, you might want to try my MacroBackerUpper macro, which I wrote as a result of having to go through this recovery one too many times :).
MacroBackerUpper creates a Time-Machine-like set of backups of your macros, making it easy to recover any number of macros from any number of points in time.
-rob.