@Ogigi
Please download following zip and extract it into your project after you have backuped your original files
Ogigi.zip (16.2 KB)
- EmplyeRecords: I corrected one value and changed decimal seperator from dot to comma
- TotalRecords: A Template Worksheet is added
- the XAML
- vba Macro file doing Worksheet Copy and Renaming
Rewire all paths accordingly to your environment
Ensure your excel allows Macro Execution e.g.
- By trust the object modell tick to On
- Open Excel file GoTo Option->Click Trust center->clickMarco Setting->Enable the marco , Save it
Give a try on which one will work
In case of an error regarding the Total Sum Computation
- share screenshot with (Set Breakpoint before failing activity, Do debug, Locals Panel, Expand dtData Variable)
Due the local settings the Double Parsing needs some adjustments, but I already preimplemented this case and let you know the resolution steps for it.
Let us know your feedback