I have 2 excel file, I need to get the total working hours and ot hours for an employee then write it to another excel file on the sheetname that depends on the employee name with a specific cell

@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