Here is the scenario that I am working on:
- Read workbook having URLs in a data table. Add additional columns to data table
- In a For Each row, iterate through each URL and Open a Chrome Browser and paste the URL
- Click on Enter. Then select the extended URL from Chrome browser and copy it to a clipboard and into a variable.
- Now, I want to update the datatable with the value in the variable to the newly created column in the data table. I am also using a counter variable to update the counter each time new URL is iterated through.
Step 4 is not happening. Below is the code that I am using to do that:
dtOutput.Rows(counter).Item(" Full URL") = strCopied
strCopied = has the value from the Clipboard
Full URL = newly added column in data table