You’re offline. This is a read only version of the page.
15
Hi 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);
Hi,
you can develop your own extension using Al code
for more info, you can refer to the below link
community.dynamics.com/.../import-excel-file-using-al-extension---d365-bc
Share
Report
All responses (
Answers (
