|114721||Dec 5,2013 07:02 AM||Dec 11,2013 06:12 AM||ASP.NET Web Forms (Classic)||2|
I am using xlsio 184.108.40.206 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)
The Workbook is a Excel 2010 macro enabled workbook (xlsm) file.
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.