Not able to write in Excel from asp.net

[mady1380]

hi all

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

I am able to read the data of particular cell, but i am not able to write in Excel file.

I am getting error: ComException: Document not saved;

Any help would be appreciated.
thanx.

*****************************************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 = "Example"

MyExcel.ActiveWorkbook.SaveAs("C:\Inetpub\wwwroot\ AddNewPromotion\Excel2.xls")
MyExcel.ActiveWorkbook.Close()
MyExcel = Nothing
MyWorkbook = Nothing
MySheet = Nothing

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