how to save excel sheet after making changes to an opened excel sheet or how to take object of the excel file at the run time
Posted on 2005-04-26
I wil have to open an excel sheet on the browser.I do this by
Response.ContentType = "application/vnd.ms-excel"
but after opening the excel sheet i want to make some changes on this excel sheet then save it to the same location , unable to do this bcoz i dont have run time object of this excel sheet.
when i tried to do this by
Dim xlobj As New Microsoft.Office.Interop.Excel.Application
it gives error :- object reference not set to an instance of an object