Recover VBA code from corrupted .xls file?
Excel 2002: Several days' work is tied up in an .xls file that
mysteriously got corrupted and now I can't open it without Microsoft
"repairing" it by stripping out all the VBA code and the embedded
controls.
I have medium-level macro security control turned on, and I disable
macros when opening the file, but it still comes up with "Microsoft
Excel has encountered a problem and needs to close". Then if I take
the option to "recover and restart", all the VBA code is stripped out.
Is there any way to bypass opening the file with Excel and extract the
VBA modules?
Thanks,
Ken Dahlberg
|