Excel application scope, dynamic file base file path

I have the following scope of Excel as part of a workflow. However, every day the name of the file changes, that is, there is a folder where several Excel files are downloaded. I need the robot to open the files and processes one by one, how can I make the robot open each file? How can I make the path change every time I enter a new file?
Any suggestions? anotacion
thanks.

HI
welcome to uipath community
hope these steps would help you resolve this
–use a assign activity like this
arr_filepath = Directory.GetFilest(“yourfolderpath”,“*.xlsx”)
where arr_filepath is a variable of type array of string
–now use a FOR EACH activity and pass the above variable as input
and change the type argument as string in the property panel of for each loop
–inside the loop use this EXCEL APPLICATION SCOPE and mention the filepath as item.ToString

this will open all the files in that folder one by one

Cheers @jpassos01

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