Thanks for the help, it did helped but partially. The BOT is now picking the right rows (i.e. the rows having status as ‘NULL’) to insert into the application. However, the status column is not being correctly updated with a ‘Pass’ or ‘Fail’. I’m using the below syntax to get the status updated for the rows which have been picked up for processing having status as ‘NULL’ but it is updating from row 2 and not just the one which has been processed.
“C” + dtCitrix.Rows.IndexOf( rows ( counter))+2}.ToString
This is giving me “End of expression expected” error.
Below is a sample of what is required:
BOT should pick up row 3 and 5 for processing as ‘Status’ value is ‘NULL’ for them and after processing it should update ‘C3’ and ‘C5’ as ‘Pass’ or ‘Fail’. This is placed inside a Try Catch.