Use Excel File activity using wrong folder

[mlivings]

I am working on a project in StudioX and running into an issue. I am needing to go into each excel file in a folder and gather data. I have a ‘for each file in folder’ activity with a ‘use excel file’ activity nested in it. In my ‘for each file in folder’, I have indicated the folder that I want it to use. However, when it gets to the ‘use excel file’ activity, it is trying to open excel files in the project folder, not the folder I indicated in the ‘for each file in folder’ activity. Why is it doing this and how do I correct it?

In the first image is the path I have selected in the ‘for each file in folder’ and the second image is the path that the ‘use excel file’ is trying to pull from. Third image is how I have things set up

The path I have chosen for it to use is L:\Operations… and it is pulling from the project folder N:\UiPath\Data… (… instead of rest of file path).

[mlivings]

Please disregard the ‘first image/second image’ portion of this, I was only able to attach one image and forgot to remove that before posting. Thanks!

[Anil_G (Anil Gorthi)]

@mlivings

Use currentfile.fullname and not name

Cheers

[mlivings]

Thanks Anil! That worked.