VBA Macro Bug find

Hi all,

We want to find a bug in a VBA macro which use Kryon export files and xlms templates.
We have isolated a case study happened on April 1st, so I've prepared a full data folder which contains:

- Kryon extraction folders, which are used as input from VBA macros (Attivita, CBK, CPSI, MNT, SickUnits)
- Output folder, where the macro generates an output file for each region template xlsm.
- LOGS folder, with the log recorded
- "Report Operativo Manager.ini" file, which is the configuration file used by VBA macro
- "Report Operativo Manager.clsm" file, which contains the macro "start_Import_Unattended" called remotely
- 17 files "SCHMIL_OPERATIVO TEMPLATE_26XX.xlsm", which are template for every region and are used to generate the file in Output folder.

I forward you the email from our Product Owner who reports to us in detail all missing values generated by the macro "start_Import_Unattended" called remotely after generating all the Kryon files.

-----------------------------------
Like every week, some "random" data on the 17 reports are missing.
Some are common for many of the 17 reports, others only manifest themselves in some.
This has happened since the beginning of the year and often with the publication of the new week they settle down, only to reappear in a "random" way.

Below, what we found this week:

1) Common for all 17 reports
Sick units (both in % and in number) : the value of column H must be the same as that of column V

2) Report specific:
2603
#Visite S Scadute : column U should remain zero as visits not performed in the month must be charged every 4 weeks, i.e. at the change of the month.

2604
#Visite S scadute : The same, with the addition of the T column which instead should be zero
Media Tempi e NC : column H is not powered on the Mauro Opini sector

2605
#Visite S scadute : as for 2604 (columns T -U should be zero)
Sick Units : the values of the last three weeks are missing (columns s-t-u-v) both in % and numerical value

2608
Media Tempi e NC : column H is not powered on the Roberto Cesarano sector

2613
% ore amministrative (column H) total times are missing (#DIV/0!)
NC (always column H) part of the data is missing (#DIV/0!)

2614
#Visite S scadute : as for 2605 (columns S-T-U should be zero)
% ore amministrative (column H) total times are missing

2616
% ore amministrative (column H) total times are missing

2620
% ore amministrative (column H) total times are missing
#Visite S scadute : as for 2605 (columns S-T-U should be zero)
%FR totale: column H sector Andrea Zecchillo, incongruent value

-----------------------------------

I can send a zip file for whom interested.

Thanks