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

Like (0) Share

Report

Posted on 3 Dec 2022 01:52:19 by 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

I have the same question (0)

All responses (2)

Answers (1)

RonCinTN 15 on 03 Dec 2022 at 13:04:37

Like (1)

Report

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

VJR,
Thanks! That was it.
Much appreciated.
-Ron

Was this reply helpful? Yes No
Verified answer

VJR 7,635 on 03 Dec 2022 at 02:21:34

Like (1)

Report

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

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

Was this reply helpful? Yes No