<div>
this works fine but what we have to do is - my excel file is opened in browser and then make some changes , so to do this i have to take the object of the excel sheet at run time and then through that object i will save the file but unable to get the object at run time.
</div>


this works fine but what we have to do is - my excel file is opened in browser and then make some changes , so to do this i have to take the object of the excel sheet at run time and then through that object i will save the file but unable to get the object at run time.

<div>
<div class="content wysiwyg-content">
I wil have to open an excel sheet on the browser.I do this by <br />
<br />
Response.Clear() <br />
<br />
Response.ContentType = &quot;application/vnd.ms-excel&quot;<wbr /> <br />
Response.WriteFile(&quot;../Fil<wbr />es/jaya.xl<wbr />s&quot;) <br />
<br />
Response.End() <br />
<br />
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. <br />
when i tried to do this by <br />
<br />
Dim xlobj As New Microsoft.Office.Interop.E<wbr />xcel.Appli<wbr />cation <br />
xlobj.ActiveWorkbook.Save(<wbr />) <br />
<br />
it gives error :- object reference not set to an instance of an object <br />
<br />
<br />
<br />
Best Regards, <br />
SoftSolvers <br />
dotnet@softsolvers.com <br />

</div>
</div>


I wil have to open an excel sheet on the browser.I do this by 

Response.Clear() 

Response.ContentType = "application/vnd.ms-excel" 
Response.WriteFile("../Files/jaya.xls") 

Response.End() 

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 
xlobj.ActiveWorkbook.Save() 

it gives error :- object reference not set to an instance of an object 



Best Regards, 
SoftSolvers 
dotnet@softsolvers.com 


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

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.