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.
Unfortunately, activation email could not send to your email. Please try again.

Using WorkBook.Save or SaveAs changes originally opened WorkBook

Thread ID:

Created:

Updated:

Platform:

Replies:

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

Hi,

I am using xlsio 8.103.0.30 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)

workBook.Close()

End Using

 

Best regards
Pål Eilertsen


Pål Eilertsen
Replied On December 5, 2013 07:03 AM

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


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

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

Thanks,
Johnson

CONFIRMATION

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.

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.

;