How to click URLs from spreadsheet and copy back the extended URL

Hi there,

I am working on a project where I need click on each of the URL provided in one of the columns of a spreadsheet. These URLs may open up pdf/word documents. Some of the URL also open up windows explorer, which I need to skip. Once each of the pdf/word documents open up, I need to select the extended URL from the browser and split the filename and the extension and write it back to spread sheet in new columns.

So far I have been able to read the specific column of the spreadsheet where URL are located and store it a data table. I know that I need to iterate through the data table using for each activity. However, I am not sure how to click each of the URLs and then copy the extended URL write it back to the spreadsheet. It would be great if someone can provide me a way through this.