Can use C# to create and save excel file. But can't reopen the file as it crashes

[I Decker]

Hi all,

Hope this is the right group.

I am writing a program in c# to open create an excel document, enter
some data, save it and then email it as an attachment. I have
successfully created an excel document which the user can see (at this
stage of development) and passed some data to it. I then used the
savas method to save the file. Again this seems to work as the file is
created. However once I close the excel file and try and reopen it
from the automatically saved version I get the following error
message, which results in it being impossible to open the excel doc.
This happens not just on my machine, but any computer that tries to
open these files.

Error message title bar reads as follows

Microsoft Excel – DebugMy Sheet.xls: Excel.EXE – Application Error

The body of the error message reads as follows

The instruction at "0x30004561 9" referenced memory at "0x00050018 ".
The memory could not be "read".
Click on OK to terminate the program
Click on Cancel to debug the program

I have research similar errors on Microsoft's site and have search
newsgroups. Although lots of people seem to get similar errors, they
seem to be caused by different situations and are not applicable to
what I am doing

I am using C# code and Excel 2000

I hope somebody has an answer

Here is my code
---------------------------------
//create excel file and data
Excel.Applicati on ExcelApp;
Excel._Workbook ExcelWorkbook;
Excel._Workshee t ExcelWorkSheet;

ExcelApp = new Excel.Applicati on();
ExcelApp.Visibl e = true;
ExcelWorkbook = (Excel._Workboo k)(ExcelApp.Wor kbooks.Add(
Missing.Value ));

ExcelWorkSheet = (Excel._Workshe et)ExcelWorkboo k.Sheets["Sheet1"];
ExcelWorkSheet. Name = "My Sheet";
//Make sure Excel is visible and give the user control
//of Microsoft Excel's lifetime.
ExcelApp.Visibl e = true;
ExcelApp.UserCo ntrol = true;
//text in cell
ExcelWorkSheet. Cells[1, 1] = "test sheet";
ExcelWorkSheet. Cells[3, 1] = "test1";
ExcelWorkSheet. Cells[3, 2] = "test2";
ExcelWorkSheet. Cells[3, 3] = "test3";
ExcelWorkSheet. Cells[3, 4] = "test4";
ExcelWorkSheet. Cells[3, 5] = "test5";
ExcelWorkSheet. Cells[3, 6] = " test6";

ExcelWorkSheet. get_Range("A3", "F3").Horizonta lAlignment =
Excel.XlHAlign. xlHAlignCenter;

ExcelWorkSheet. get_Range("A1", "A1").Font. Bold = true;
ExcelWorkSheet. get_Range("A3", "F3").EntireCol umn.AutoFit();
ExcelWorkSheet. get_Range("A3", F3").BorderArou nd(Excel.XlLine Style.xlContinu ous,Excel.XlBor derWeight.xlMed ium,
Excel.XlColorIn dex.xlColorInde xAutomatic,Exce l.XlColorIndex. xlColorIndexAut omatic);

ExcelWorkSheet. get_Range("E1", E1").Columns.En tireColumn.Numb erFormat =
"£###,###,##0.0 0";

string savepath;
savepath = Application.Exe cutablePath.ToS tring();
savepath = savepath.Substr ing(0,savepath. LastIndexOf("\\ "));
savepath = savepath + "\\TestExcelFil e.xls";

ExcelWorkbook.S aveAs(savepath, Excel.XlFileFor mat.xlCSV,Type. Missing,Type.Mi ssing,Type.Miss ing,
Type.Missing,Ex cel.XlSaveAsAcc essMode.xlNoCha nge,Type.Missin g,Type.Missing,
Type.Missing,Ty pe.Missing);

-------------------------------------
Thanks again

I Decker