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

0 votes
Oct 11, 2019 in RPA by Aiza
• 120 points
1,030 views

1 answer to this question.

0 votes
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?
answered Oct 14, 2019 by Abha
• 27,930 points
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!

Related Questions In RPA

0 votes
4 answers

How to find the sum of 2 columns of an excel and display it in a 3rd column using UIPATH?

These are the steps to add two ...READ MORE

answered Aug 2, 2019 in RPA by Shivi Singhal
5,830 views
0 votes
1 answer

how to extract information from a pdf using regex and send that information to an excel spreadsheet?

You can use the following high level activities to ...READ MORE

answered Apr 9 in RPA by Karan
• 11,070 points
99 views
0 votes
1 answer

How to select an item in UiPath that starts with a string

use a wildcard in selector. make sure that ...READ MORE

answered May 21, 2018 in RPA by wrecker
• 3,110 points
1,875 views
0 votes
1 answer

How to select an item in UiPath that starts with a string

Just use a wildcard in selector. Given ...READ MORE

answered May 28, 2018 in RPA by wrecker
• 3,110 points
377 views
0 votes
1 answer

How to select an item in UiPath that starts with a string?

Just use a wildcard in selector. Given ...READ MORE

answered Jun 29, 2018 in RPA by wrecker
• 3,110 points
564 views
0 votes
1 answer

How to delete some specific sheets from an existing excel file using vb.net code?

You can create a output of Excel ...READ MORE

answered Jul 27, 2018 in RPA by Atul
• 5,530 points
1,184 views
0 votes
1 answer

What is the recommended way to open an application as part of a task in Automation Anywhere?

The recommended methods for opening an application ...READ MORE

answered Apr 1, 2019 in RPA by Iffath
• 1,180 points
950 views
0 votes
1 answer

How to assign a data in a variable in to excel file?

System -> File -> Workbook -> Append ...READ MORE

answered May 22, 2018 in RPA by wrecker
• 3,110 points
184 views
0 votes
1 answer

How to read data from a excel, based on that data, check in the corresponding checkbox in browser appln? Uipath

Hi, to achieve this, you can perform ...READ MORE

answered Oct 10, 2019 in RPA by Abha
• 27,930 points
634 views
0 votes
1 answer

Is there any way to check whether a file exists or not using UiPath?

Hi @Raj, performing this check in UiPath ...READ MORE

answered Mar 20, 2019 in RPA by Abha
• 27,930 points
2,852 views