I have faced the below mentioned issue in NAV 2016 Database.
Hi! You need to replace automation to dotnet variables. It's not very complicated.
Thanks for your instant reply.
I know that the automation to dotnet is my last option. But how the same is working fine in NAV 2013 ?
Some of the Architectural change, As a generic process I will always recommend to use DotNet Variables instead of Automation.
NAV 2013 had less control over Denial Of Service issues by design, from NAV 2015 the security policies have changed (restricted by Design),
use DotNet Variables.
Is there any default DotNet Variable exists for Microsoft Script Control 1.0 ?
Check this one:
This is pseudo code which I need to execute thru the dotnet variable. This VB script is used to insert a entire row into an excel sheet.
Where do I get the same functionality in dotnet variable ?
ScriptCtrl.AddCode('SUB Insert()' + ............... CrLf + 'END SUB');
UNTIL rec.Next =0;
Look at table 370 Excel buffer. Here we have functions for creation and managing excel books. It's much simple than doing the same with VB scripts.
Also in RU localization there is codeunit 12416 Excel Management.
Thanks for your advice!
The Excel Buffer and Excel Automation are not performing well while exporting bulk record. But the VBScript code is performing very fast.
The Script exports an EntireRow while exporting into excel.
Business Applications communities