- I need to access excel files that downloaded from a web browser that get put into the download folders and move them into another file path area.
- There are 4 files and they say Export.xls, Export (1).xls, Export (2).xls, Export (3).xls. I need to create a loop so they can read those files in the download folder and move and rename them into a different folder.
So how can I get the automation to read the files in the download folder with the numbers in parentheses to be able to move them into another folder path and rename them. I am able to rename and move the first Export without the numbers after it, but I can’t figure out how to get it to read the other files with the numbers in parentheses as well.