I want to create an Excel file and include a chart from scratch, and I'm using DotNet functions but when trying to get hold of a handle to ChartObjects I get an error:
Exception HRESULT: 0x800A03EC
The C/AL code:
XlApp := XlApp.ApplicationClass;
XlWrkBk := XlApp.Workbooks.Add(-4167);
XlWrkSht := XlApp.ActiveSheet;
XlWrkSht.Name := 'Item Flow Data';
XlChartObjects := XlWrkSht.ChartObjects(Missing); <---- The error occur on this statement?
Does anyone know whats wrong?
I'm working in NAV 2015 version 8.00.37874....