I have been struggling to figure out how to find out if in cells in excel is file name from folder (without PDF) and if so then write into same row “Approved”.
So far I have READ RANGE with Datatable dt1 and
with Output - index
row(“My column name”).ToString.Equals(“fileInfo”)
Write cell with Range “R” + (index + 2).ToString
It never writes what I need.
Can someone help, please?