Does anyone know how to open an existing Excel file to write data in it? Is there a variant to this? **** excel = SysExcelApplication::construct(); books = excel.workbooks(); **** thx for the help. Kathleen
I do not know the Axapta syntax, but in Excel Automation, the next step would be book = books.open(filename);
book is an Automation variable of type Excel.Workbook.
Here’s some Axapta code sample : SysExcelApplication excel = SysExcelApplication::construct(); str fileName = excel.getOpenFileName(); if (fileName != “”) { if (excel.workbooks().open(fileName)) { // You now have an opened workbook. } }