How Do I do this Loop?

[nahanis]

I want the Studio to “read” and “click” one cell from Excel > go to the web > Click Action/Buttons > Process 1 Done > Repeat

Repeat the process to next cell until there is no more Link to select

Thank you in advance!

[Dave (David Wiebelhaus)]

What all have you tried so far, and which part are you getting stuck on?

[Yoichi]

Hi,

If your worksheet uses HYPERLINK function, the following sample might help you.

Sample20220826-1.zip (12.6 KB)

Regards,

[nahanis]

Hi Yoichi! I do appreciate your screenshot! As I am trying to follow your formula I could not find the “Excel Process Scope”/“Use Excel File”/“For Each Excel Row”

[nahanis]

I’ve updated the Excel Package on Manage Package and I attached screenshot what version UiPath im currently using Part 1

[Yoichi]

Hi,

Can you turn on ModernDesignExperience in ProjectSettings OR turn on “ShowModern” at Filter in Activities panel?

Regards,

[nahanis]

I’ve updated the Excel Package on Manage Package and I attached screenshot what version UiPath im currently using Part 2

[nahanis]

Found It!
I’m working on it

[nahanis]

I’ve encountered another issue here:

I type in manually until the “?<=HYPERLINK” within the Assign > strLink but i dont think i have the Yen currency.
Do I simply replace with dollar currency?

[Yoichi]

Hi,

@nahanis

Yen currency

Please consider it as back-slash \. It’s due to Japanese character mapping.
I attached sample project as zip file in my previous post. Can you also check it?

Regards,

[nahanis]

I have unzipped your attachment. It does work but the URL is empty, therefore it only open empty web browser

[nahanis]

I use simple link like google-com, yahoo-com, msn-com but the variable is not registered

[Yoichi]

Hi,

Can you share your workbook? It’s no problem if dummy data.

Regards,

[nahanis]

I tried to upload but I couldnt due to being new User Restriction