Hello Rahul,
You need to insert nested loop in mentioned scenario. Main loop would be for total number of pages or loop until Next link exists and second loop would be for number of links on the webpage. Inside second loop, you can insert commands to click on 'View Profile' link, extract desired data into variable and use Excel commands to save that data in worksheet.
Text format of commands would appear something like this,
Loop While Next link exists
Extract Table to get all the links in CSV file
Loop for each row in Internet Explorer table
Extract Data
Excel Commands
End Loop
End Loop
If you can provide URL of website then we can create specific sample task for you.
Hope that helps.
|