Can't continue click Excel scroll area by For Each Activity

Help StudioX
,
1

Hello All!
Now i create bellow.
Click and open link from top to down by for each activity.
In ths case, from A to CC as OK.(Visible link)
But actualy more link, but can’t click next link(more down scrole area link)
Please help, how to continue for more down scrole area?

aa
aa321×833 51.3 KB

bb

cc
cc614×657 50.7 KB

Regards,

2

HI,

How about to press Down key using Keyboard Shortcut activity after (or before) clicking as the following?

image

Regards,

3

@Takayuki1

we can use read range and get the links and then using for each row in datatable activity can look through each row and then use open/use browser activity to pass the url and open it

Cheers

4

Thank you replay for all.

For Yoichi-san
I’m shortage explanation. Already try to keyboard shortcut, but Up to the first visible link is OK.The first invisible link fails even though I set the keyboard to scroll down and the link is visible.

For Anil_G-san

If you don’t mind, please explain more details because of beginner.

Regards,

5

HI,

Can you share your project? it’s no problem if dummy data.

Regards,

6

@Takayuki1

Please follow the steps…

  1. Use workbook read range activity and read the data into datatable dt
  2. Now use a for each row in datatable on dt
    3.Inside the loop currentrow(“Columnnamewithurl”).Tostring will give you the url
  3. Pass the url to open browser or use application/browser activity

Hope this helps

Cheers

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.