I have some excel files in the same folder, I want to use For Each activity to check all of excel files exists in folder… When run process, it will show a Input Box and I will input the " Code " which I want to find … it will find this code in Column C of each excel file… If it found, it will write all row into new excel file.
Use Directory.GetFiles(sourcePath, “*.xlsx”) to get all the excel files
Create a data table (dtResult) to store the rows of the said code.
Use Input Dialog to capture the code.
Use For Each to loop to each file path.
4.1 . Use read range and use the item.tostring as the file path
4.2. Use a for each row to loop to the rows of the data table (dtCodes) containing the
excel info.
4.2.1 If row(“Code”).ToString = strCodeInput.ToString, Add Data Row
4.3 Clear the Data Table (dtCodes)
Use Write Range or Append Range to Results.xlsx.
I am not sure that this will be it but this is the logic.
I think it is best that you will do the robot configuration yourself and we will just assist you.
Thank you!
