Hi. I am new at this. I am wanting to run a “For Each Excel Sheet” activity, but I need to Exclude 3 Sheets from loop. I have tried doing this by inserting an “IF” activity to see if the sheet name is one of my exclusions and to skip the tasks. This doesn’t seem to be working, as the For Each is still processing each of the sheets. (I have a write line activity outputting the sheet names as they are processed.) I have tried both the “AND” and “OR” options in the If statement but to no avail.
Below are screen shots of my Activities.
“For Each Excel Sheet” activity with “If” statement
Here is the Condition Builder with the 3 Sheets I wish to exclude. (i have tried variations of “And”/ “Or” and also with and without speech marks around the sheet names.)
Not sure what I am doing wrong. Thanks for any assistance you may be able to provide. I have search the community but cant seem to find a similar question / solution.