Question

How to open an excel file with a dynamic file name such that the file name is FXTB- date today using UI Path

Answer 1

Hey Alza, I am trying to understand what is the problem here, because you can open any excel file by using Excel Application Scope. If you have more than 1 file, then you can use a loop to open them one by one. Why having a dynamic name is of concern to you?

Comments

Hi,

The thing is when specifying the file name, I put * for the dynamic part as below:

Excel Name:

report1594211209235

The full path at the Excel Application Scope:

"C:\Users\XXX\Downloads\report*.xls"

But robot throws error as below probably because of that asterisk:

"Illegal characters in the path" but the name of the excel changes each day lets say, so I cannot put a fixed name.

How can i fix it?

Thank you in advance,

Best,

Cagla

---

Hi @Cagla,

For the Excel Application Scope, you have to give the actual file path. “*” is actually not going to work here. In case you have file names in a particular folder that changes from time to time, You may get the file names into an array first. And then loop through them to open the file.

Hope this helps!