I am not sure what is wrong, but I keep re-looping to Row 0. I checked by writing to a messagebox
My process flow:
Unless the process flow in my flowchart somehow re-set my DT. Is there anyway to check? Thanks in advance!
Everything seems ok to me. Could you share your workflow so I can take a look?
Instead of DT1.Rows.IndexOf(row)
just try using row(0).ToString
Hope this may help you to solve your query
Mark as solution if this helps you and like it
Er Pratik Wavhal
I don’t think you understand the Qn. I can’t break out of the loop. Not sure what it has to do with changing to row(0).ToString
Hy, you could use a log message to watch the progress of your data table rows, use a counter
something like this
i = i +1
i.toString / DT.Rows.Count.toString
please git it a try and let me know.
I checked that I got out of the “For Each” Loop because I get the messagebox “Out of Loop”.
But the strange thing is that it repeats itself and go thru the “For Each” loop and I get the messagebox again.
Anyone knows why this is happening? I am using a sequence.
Could you share your workflow with me so I can take a look?
Test.zip (2.1 KB)
Thank you for your reply. I have attached my workflow. It is within a flowchart as I have many processes which I have removed in this file.
The issue is that the workflow keep re-opening my Excel and goes thru the same steps although it is a sequence.
Could it be because it is within an Excel Application scope?
The workflow “keeps re-opening the excel because the visible options is checked”
Please uncheck it!
The rest seems ok!
Try this and let me know if it works
Thanks for the reply. I un-checked the visible option, but my Excel fille still keep re-opening.
Check in your workflow if there are any other Excel Application Scope, this visible button is the only option that would open your excel file.
Everything seems to be correct, Keep a message box before excel application scope and before for each data row.
@Anonymous2 @William_Blech_Sister @Zorojir
The problem is with how you have connected your excel application scope, It is reconnected to itself