After running activity “Run Spreadsheet Macro” within a “For Each File in Folder” activity, I need to read cell K2 from the macro results. If the value in cell K2 equals “0”, then I want to move file to a different folder, if not equal to “0” then keep file where it is.
Problem is, I can’t figure out how to read cell K2 after the macro finishes. Running macro and moving files works fine. But cant read cel K2 to determine where to move the file. Please see screenshot of my workflow. Error occurs on “Read Cell Value” activity. Please help if you can.
Error ERROR Validation Error Compiler error(s) encountered processing expression “Excel”. Option Strict On disallows implicit conversions from ‘UiPath.Excel.IWorkbookQuickHandle’ to ‘UiPath.Excel.IReadCellRef’. Main.xaml***