Hi Martin,
My speculation is that there is something in your macros that is causing a problem.
I had a similar problem recently that was caused by a Macro that used the following code excerpt:
The length of the 'Formula1' string (
sDataValidatationString) MUST be 255 characters or less. When the string was longer than 255 characters, the file worked normally and I could save the file fine. After I opened the flie again, I would get the dreaded file was corrupt message similar (but not the same) as yours. It took me two weeks of detective work to determine what my problem was. The fix was to have the list on the Spreadsheet and have Formula1 use a Range (e.g. 'sFormula1 := "='Sheet X'!$E$3:$E$5" ).
My suggestions:
a. Make a MASTER .xlsm copy of your file that contains no Macro code modules.
b. Make a copy of the MASTER .xlsm file
c. Introduce Macro Modules and run their code. Save the file and exit Excel.
d. Open the file, and if there is no corruption, this is your New Master file.
e. Repeat until the problem is found.
I hope this helps.
Lewis
Bookmarks