Error:[COMException (0x800a03ec): Document not saved.]

[mady1380]

hi

I am just a starter in programming.

i am trying to read and write data to Excel from asp.net

i am able to read a particular cell from my Excel sheet but i am not able to write and save into it.
any help would be appreciated..
thanks.

**************************My Code**********************

Dim MyExcel As Microsoft.Office.Interop.Excel.Application
Dim MyWorkbook As Microsoft.Office.Interop.Excel.Workbook
Dim MySheet As Microsoft.Office.Interop.Excel.Worksheet
Dim MyCell As Microsoft.Office.Interop.Excel.Range

MyExcel = New Microsoft.Office.Interop.Excel.Application
MyExcel.Workbooks.Open("C:\Inetpub\wwwroot\AddNewP romotion\Excel1.xls", , False)
MyWorkbook = MyExcel.Application.ActiveWorkbook
MySheet = MyWorkbook.ActiveSheet
Label1.Text() = MySheet.Cells.Item(1, 1).value

MySheet.Cells.Item(2, 2).value = "madhu"

MyExcel.ActiveWorkbook.SaveAs("C:\Inetpub\wwwroot\ AddNewPromotion\Excel2.xls")

MyExcel.ActiveWorkbook.Close()
MyExcel = Nothing
MyWorkbook = Nothing
MySheet = Nothing

**********************End************************* *********

[AricC]

Try this out:
.Net + Excel
Or...
Some of these:
More