Hello,
Yes, it can be done using Automation Anywhere. We have created a sample task to show how you can do this. Please copy attached .atmn file under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder. Copy Book1.xls under C:\.
Task would fetch the URL from Book1.xls and would paste the new URL in the next column of same row. Task will loop until all the URLs in excel file are processed.
Hope that helps.
|