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