I put several days into writing a bunch of macros to keep track of my
baseball card inventory. As I was saving, Excel (2000) crashed. The
file was in 97 format. I can open it at home with 97, and it "knows"
there are macros there, but if I try to access them, Excel crashes.
At work in Excel 2000, the file won't even open. I believe the first
spreadsheet tab is the problem, as it acted weird before the crash
(hence why I started to save it).

My problem seems specific, but I can see a general application: what I
need is a macro that will go into a file and read any (hopefully all)
macros in a file and then make the code accessible to copy somewhere
else. Where I can see this as helpful would be if someone wanted a
code to examine a file before opening it with macros.

Is this possible?

(BTW, I did try two on-line recovery services, as well as some trial
software, and none of them could pull the macros out).