Support Portal

for ProcessRobot and WinAutomation

Start a new topic
Answered

URL - List of URLS in Excel. I need to cycle through 1 at a time and run

I have a list of URLS

I want to start at the top. Open that URL, Copy the path, delete the row so its no longer on the sheet and then do the job i have programed then close and get the next one and continue on.....


HOW?


Best Answer

Hello Brett,


Please do the following:

-Use the Launch Excel Action , to instantiate the excel file that you want to use.

-Use Get First Free Column and Row Action.

-Use Read From excel Worksheet (the range of cells that contain the urls). 

-Use Launch New Chrome (or other browser) Action

-Use the For Each Action (to iterate through each website)

-Use Go to Web Page Action (and use the variable of "For Each" Action)

-Lastly, add your functionality!


Does this works for you?


ADMIN
Answer

Hello Brett,


Please do the following:

-Use the Launch Excel Action , to instantiate the excel file that you want to use.

-Use Get First Free Column and Row Action.

-Use Read From excel Worksheet (the range of cells that contain the urls). 

-Use Launch New Chrome (or other browser) Action

-Use the For Each Action (to iterate through each website)

-Use Go to Web Page Action (and use the variable of "For Each" Action)

-Lastly, add your functionality!


Does this works for you?

Hi There.

Can you please see attached and let me know where I am going wrong.


My excel has a list of URLS in Column A and starting from row 1. There is about 500 of them. I want it to get them and just work the way through


image

waj
ADMIN

Hello Brett,


In action #3 you need to read a range of cells, so as to grab multiple data and iterate through them. Please see image below for reference:


You are a superstar. It worked! Thanks heaps
ADMIN

You are welcome!
Keep on automating :)


Login or Signup to post a comment