Looping though an Excel worksheet to read a website and extract a single data for each to write back in the worksheet
12-02-202205:52 PM
I have what I think is a simple procedure that I need some help.
I have an Excel file with a list of websites. I want to loop through reading a website address, opening it, extract one piece of data (it's in the same place on every website in the spreadsheet), and populate the spreadsheet with the information.
This is what I have.
It is erroring on line 8: "Invalid URI: The Uri string is too long."