softsolvers
asked on
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
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("../Fil es/jaya.xl s")
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.E xcel.Appli cation
xlobj.ActiveWorkbook.Save( )
it gives error :- object reference not set to an instance of an object
Best Regards,
SoftSolvers
dotnet@softsolvers.com
Response.Clear()
Response.ContentType = "application/vnd.ms-excel"
Response.WriteFile("../Fil
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.E
xlobj.ActiveWorkbook.Save(
it gives error :- object reference not set to an instance of an object
Best Regards,
SoftSolvers
dotnet@softsolvers.com
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER