I am having some issues with creating a Foreach loop container that will loop through the worksheets of a particular Spreadsheet. One of the problems is knowing what Index number to assign to my Worksheet variable. (See Attached picture) I am a little unclear what the "Index" actually is and what number I should put there. I think the default is 0 but I am getting this error message:
Error: 0xC001F009 at Package: The type of the value being assigned to variable "User::WorkSheetName" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.
I assume I am pulling something other than the name of the worksheet but I am unclear what that would be. A little more explanation would be very helpful!