Share
Report
15Hi Guys,
We are using Business Central on prem version 14 and use the NAS to auto process Excel Files to TXT. In NAV 2009 we used below code but after an upgrade to BC it isn't working anymore.
The reason is the NAS isn't able to handle automations anymore. We tried to rewrite the code and use .Net but it is failing. Could you please assist?
PREVIOUS CODE 2009:
IF EXISTS(NewFileName) THEN
ERASE(NewFileName);
IF ISCLEAR(ExcelApp) THEN
CREATE(ExcelApp, TRUE, TRUE);
ExcelApp.ScreenUpdating(FALSE);
ExcelApp.DisplayAlerts(FALSE);
ExcelWorkbook := ExcelApp.Workbooks.Open(FileName2);
ExcelWorkbook.SaveAs(NewFileName, 6);
ExcelWorkbook.Close(0);
ExcelApp.Quit;
NEW CODE BC:
IF ISNULL (XlApp) THEN
XlApp := XlApp.ApplicationClass;
XlApp.ScreenUpdating(FALSE);
XlApp.Visible(FALSE);
XlWorkbook := XlApp.Workbooks.Open(FileName2, 0, FALSE, '', '', '', FALSE, 2, '', FALSE, FALSE, 0, FALSE, FALSE, '');
XlWorkbook.SaveAs(NewFileName, 6, '', '', FALSE, FALSE, 1, '', FALSE, '', '', FALSE);
XlWorkbook.Close(FALSE, '', FALSE);
XlApp.Quit;
CLEAR (XlApp);
All responses (
Answers (
