MohanGururaj
New Member
Hi Folks,
I need sheet count for all the workbook in the particular folder. This is my flow chart.
View attachment Flow.JPG
Overview:
Now there are three files, each have 3 sheet tabs.
So, Get worksheet names will update "Sheettab names" collection one by one.
Then, I have inserted Append rows to collection to get all the 9 sheet tab names and to be stored in "Output collection"
I have inserted "Count rows" from "Collections" VBO and its need to update the count in "Sheet count" data item once the loop is completed
But when I drag the "Output collection" into Collection name (Input tab) I am getting the error as below.
View attachment Error.JPG
Even I have tried this way,
View attachment second try.JPG
But no luck, I am getting the below error. Unable to trouble shoot where is the mistake...
View attachment Error2.JPG
Kindly provide your suggestions.
Thanks in advance
Mohan G
I need sheet count for all the workbook in the particular folder. This is my flow chart.
View attachment Flow.JPG
Overview:
Now there are three files, each have 3 sheet tabs.
So, Get worksheet names will update "Sheettab names" collection one by one.
Then, I have inserted Append rows to collection to get all the 9 sheet tab names and to be stored in "Output collection"
I have inserted "Count rows" from "Collections" VBO and its need to update the count in "Sheet count" data item once the loop is completed
But when I drag the "Output collection" into Collection name (Input tab) I am getting the error as below.
View attachment Error.JPG
Even I have tried this way,
View attachment second try.JPG
But no luck, I am getting the below error. Unable to trouble shoot where is the mistake...
View attachment Error2.JPG
Kindly provide your suggestions.
Thanks in advance
Mohan G