I got an exception I haven’t found referenced:
Could not parse Microsoft Excel version: $
I cannot find a reference to this error, it seems a leak memory from Excel (0X00… like) but I get this error message instead. I solved it by going back to old guard methods
I happened when trying to open and close same excel file to get different sheets in a For Each loop.
Im Using Excel Scope, assigning Workbook variable and closing it after each extraction (Excel application scope, Read range, Colse Workbook)
Right now, I’ve solved it by adding a delay of 2 seconds after Close Workbooc activity, I know it’s weird but it works.
I hope it can help someone, welcom anyone who wants to take the lead
Have a nice coding!