Looping though an Excel worksheet to read a website and extract a single data for each to write back in the worksheet

[RonCinTN]

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."

Thanks in advance for any help.

-Ron

[VJR · Accepted solution]

In Line #8 you might want to Navigate to CurrentItem instead of ExcelData.

[RonCinTN]

VJR,

Thanks!  That was it.

Much appreciated.

-Ron