How to make Studio - to work on current excel file, it should also work for any random excel file

Help Studio
1

Hi,

I am trying to make a dynamic sequence that works for all excel files. I want to automate to enable auto download and pasting of Trial Balance from the cloud accounting system into an opened excel sheet.
Problem 1 : I want the Studio sequence to run for any type of of excel opened.

My error started from - send hotkey control g can only work for 1 excel file but not others

image

Problem 2 : How do I get Studio to opened the downloaded file, Copy the sheet and paste it into the first opened file earlier.

Help please.
TIA,
Ain

2

Hello @Ain_Nassir ,

Could you please explain the actual requirement with few excels? For excel autoamtion uipath is providing many activities which can work in the background instead of UIAutomation.

Please confirm whether you are looking only for ui based automation? or we can think of an alternative solution.

3

Hi @Ain_Nassir,

Do you want to combine each excel file you downloaded from the system into a different excel?You can get faster support if you share the downloaded excels and the sample data of the output you want.

Regards,
MY

4

I managed to figure this out, I went to the selector and untick “title”. Now it works for any excel that is open in my background.

image
image775×343 16.2 KB

image

Thanks,
Ain