Issue is selecting excel data on VM

Off-Topic Discussions
1

I am doing the following on a Virtual Machine

  1. Open an excel on VM
  2. Scrolling up the page on excel (using hotkeys – ctrl + up …but it doesnt take the full page up …so i have
    to scroll up page manually )
  3. RUN a macro by clicking on the excel …This macro button is located at the top of the 1st sheet
  4. A lot of records are generated on the same sheet after running macro
  5. I need to select and copy the 3rd column (File Name) and the names of files undr this column. But
    unable to set Focus on the File Name column
  6. used hot keys ctrl + shift + down for copying the file names…dut doesnt work as I am unable to set
    focus on the column Fie Name

I tried using Find Element, Find Relative Element, Set Focus but doesnt work.
Can somebody please assist me in rectifying step 2, 5, thanks I advance.
I am new to UiPath …

2

Hi @Dhananjay2020

I would recommend you to investigate a litle bit about “select and copy the 3rd column (File Name) and the names of files undr this column.” because you can put it inside a Macro.

Kind regards,
Pablo

3

HI,
Thanks for reply on this. The issue is that I cannot make changes to macro. Just i need to set the focus on a certain element and then select that cell and copy all text in the cells below it by pressing ctrl + shift + down key.