We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Using WorkBook.Save or SaveAs changes originally opened WorkBook

Thread ID:





114721 Dec 5,2013 12:02 PM UTC Dec 11,2013 11:12 AM UTC ASP.NET Web Forms (Classic) 2
Tags: XlsIO
Pål Eilertsen
Asked On December 5, 2013 12:02 PM UTC


I am using xlsio and trying to open a workbook write some text to a couple of cells and then save it again. Both Save and SaveAs completes with no errors but when opening the workbook the graph I had is formatted wrong and the VBA project suddenly has a new ThisWorkbook module (ThisWorkbook1). My original ThisWorkBook had some code in it and now this code won't run as it seems that ThisWorkBook1 is the preferred module.

Can anyone help med with this?

Using xlsEngine As New ExcelEngine
Dim application As IApplication = xlsEngine.Excel
application.UseNativeStorage = False
Dim workBook As IWorkbook = application.Workbooks.Open(filePath, ExcelVersion.Excel2007)Dim workSheet As IWorksheet = workBook.ActiveSheet
workSheet.Range("ProsjNr").Text = projectnumber
workSheet.Range("Prosjektnavn").Text = projectname
workBook.SaveAs(projectnumber & "-" & projectname & ".xlsm", ExcelSaveType.SaveAsXLS, response, ExcelDownloadType.PromptDialog)


End Using


Best regards
Pål Eilertsen

Pål Eilertsen
Replied On December 5, 2013 12:03 PM UTC

The Workbook is a Excel 2010 macro enabled workbook (xlsm) file.

Johnson Monohar M [Syncfusion]
Replied On December 11, 2013 11:12 AM UTC

Hi Pål Eilertsen,

Sorry for the delay in getting back to you.

We have analyzed the reported issue and are not able to reproduce the issue from our side. It would be grateful if you could provide us the input template to investigate further on this. However, we strongly recommend you to upgrade to our latest version which has more features and enhancements and test the scenario with that. This could resolve the issue. If you are still facing the issue from the latest version, we request you to create a Direct Trac incident from the following link to have a follow-up of the issue.

Direct-Trac Link: http://www.syncfusion.com/support/directtrac/dtnewpost

Latest Version: http://www.syncfusion.com/downloads/latest-version



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon