Excel 2003 crash on save after previous macro execution.

[Lorenzo Melato]

Hello,

I have a very strange problem with Excel 2003 and also with Excel 2000.

I have a large workbook (~12 MByte) with 9 worksheet.
On this workbook I have a complex vba macro that collect and order the
various sheet's cells data and export views of the data on some txt files.

The problem is that Excel crash when I try to save the workbook in the
following situation:

I open the workbook with marcro disabled;
I save the workbook and the save operation is done;
I re-open the workbook and I execute my macro;
I save the workbook and the save operation is done (the workbook file size
is strangely increased);
I re-open the workbook;
I try to save the workbook and excel crashes!!!

If at this point I re-open the workbook with macro disabled and I try to
save the workbook, the save operation is done and the workbook file size
decrease.

any ideas?

 

[Lorenzo Melato]

Try a reply...