Finding relative path of a tab in excel (Data Source settings)!

Help Activities
, , ,
1

I am doing a project where I need to Automate a manual task. one of the steps is changing the source of Info from one excel file in the data source settings tab. The problem is that UiPath studio does not recognize the data source settings tab, when I use the open application activity and select it, it does not come with a file path.

Reuploaded due to problem with screenshot

To find the Data source settings. Query > Edit > Data source settings
3

2

Try to use the Read Range Workbook Activity

3

Hello Areej, I am not trying to read anything from the workbook. Just have trouble getting Studio to recognize an open tab in excel.

2
21920×1024 123 KB

4

Give specific sheet name in Read Range activity then there is no need to open tab in excel.

image

1 Like
5

I am still a new member so can’t use more than one picture to make my point clear. I don’t have problems accessing a sheet, I am mostly using clicks, the problem is when I reach the data source settings tab, the click does not work since it does not recognize it. I need to use an open application activity but need the path for this tab since it does not recognize it.