C# Excel file can't be opened normally

[Jason Huang]

Hi,

My C# Windows Form application has a form frmExcel which will write data to
an Excel 2000 file MyExcel.xls.
But if the application is still runnig then the MyExcel.xls can not be
opened normally.
The MS Excel 2000 will be opened, but there's no WorkBook(or WorkSheet)
inside the Excel,
if I stop running the application, the the MyExcel.xls can open normally.
What do I need to fix this problem?
Also, if the MS Excel is running the MyExcel.xls, then the frmExcel can't
write data to MyExcel.xls, it will result in errors.
What do I need to fix this problem?
Any help will be appreciated.

Jason

 

[=?ISO-8859-1?Q?Lasse_V=E5gs=E6ther_Karlsen?=]

Hi,

My C# Windows Form application has a form frmExcel which will write data to
an Excel 2000 file MyExcel.xls.
But if the application is still runnig then the MyExcel.xls can not be
opened normally.

<snip>

Several questions:
- are you using a third party library or have you written the code yourself?
- are you making sure to close any open files in your program?