In addition to Tom's sage advice, take a look at Chip Pearson's
"Exporting All Modules In A Project". It won't solve your immediate
problem, but it will be insurance that may prevent any further
disasters.

http://www.cpearson.com/excel/vbe.htm

HTH
Paul

--------------------------------------------------------------------
Wrote nice program, saving often even did a save as to another file. exited
out of Excel 2002. Tried to go back in and both the files are corrupted. I
can recover the data but not the VBA Module I created, All the Code is gone.
Damn, many sub routines, 2 weeks worth of work.