Hi everyone!
I’ve to export some data from a Nav Table to an Excel File. My data must be sorted by a Navision field called Location Code.
My question is: Is it possible to create a different sheet by Location Code? I’m not sure if it’s possible to do this…
Thanks
munib
2
I would just use the Excel Automation and do something like this. Do a loop and everytime there is a new location code add a sheet.
xlApp.ActiveWorkbook.Sheets.Add();
xlWorkSheet3 := xlApp.ActiveSheet;
xlWorkSheet3.Name := “Location Code”;