I have an Excel file with folder names in one column.
Now I have to iterate through the rows, Check existence for each of the folder and write the result to the second column. I have done until iteration and temporarily writing it to an text file.
But i am not able to store the result in a table for writing it to excel using set range. How can i do that or is there any other possible ways to do this.
Attached the project for your reference. Please help.
Demo1.zip (1.6 KB)