Toolbox Job Queue save Excel

When running the Toolbox programs from the Job Queue, the program can update the Excel Sheet. But it does not appear to be available after the job queue runs the process. Test has been performed with the Include as Excel Sheet enabled and disabled.

The resulting Excel sheet does not have data from the run as scheduled in the Job Queue.

In the example below, it would seem that opening the program from the interactive code viewer, then accessing the Excel Sheet, or using the Run Programs option, then the Excel menu item, the updated excel data would be seen. Interestingly, the run program, Excel option seems to show a different data set than the Interactive code view.

Example:

Demo program

// Erik’s ToolBox – Example Program
var
Cust : Record Customer;
i : Integer;
LargestBalance : Decimal;
begin
if Cust.FindSet() then
repeat
Cust.CalcFields(Balance);
if Cust.Balance > LargestBalance then
LargestBalance := Cust.Balance;
Message(‘Looking at %1, balance = %2’,Cust.Name,Cust.Balance);
i := i + 1;
exset(i,1,Cust.Name);
exset(i,2,Cust.Balance);
until (Cust.Next() = 0) or (i > 10);
Message(‘Largest Balance %1’, LargestBalance);
end;