Move file after performing a process

Hello, I need your help in the process consists of the arrival of several files (excel) to a specific folder, the robot will take a file will open it and will do its due process
My questions are: how can I make the robot open only one file and process it and when I finish moving this already processed file from a folder

I am a beginner and I really appreciate the help you can provide

1 Like

varStringArray = Directory.GetFiles("c:\pathToFiles")

IF varStringArray.Length > 0
Excel Scope = varStringArray(0)
Move File = varStringArray(0)

Great this can be done in sequence within a loop
That is
Use a assign activity like this
arr_files = Directory.GetFiles(“yourfolderpath”,”*.xlsx”)

Where arr_files is a variable of type array of string

—now pass this variable as input to FOR EACH activity and change the type argument as string in the property panel

—inside the loop use SEt of activities to process that file and then use MOVE FILE activity where mention the file path as item.ToString in Oath property and in Destination property mention the folder path where we want to move them

So this will ensure that the files are opened one by one and processed and move the process file alone

Cheers @jpassos01

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.