MrExcel Publishing
Your One Stop for Excel Tips & Solutions

vba module in damaged file

Posted by Oliver on July 13, 2001 1:36 AM

how can i get the source code of vba modules in a file,
which is corrupted and therfore not to open?

Thank you very much


Posted by Kevin James on July 13, 2001 6:09 AM

not very easily


Except for what has been listed on the main page for MrExcel, there is not much you can do.

You can try to use defrag to fix the file or use some other file repair tool. If you are using WinNT, you can buy Executive Software's "DiskKeeper."

You can try copying the file to another location and then trying to open that copy. Sometimes (seldom) that works.

If you are on a network whose administrator has setup an auto-backup of PC's, you can ask your admin if there is a copy of the file.

That's pretty much it.