If you choose yes, take the scraped data and put it in excel, if no, then go to the next scraped result


I am currently trying to get some ideas on how to solve this problem. I would like to do the following

  1. If a user chooses yes to scraping a result from a website, the process will put the scraped result in an excel sheet.

  2. If the user chooses no, it will not scrape that result, and instead, go to the next result, and asks yes/no again.

So far, what I have done is scrape the data into a data table, and in a for each loop, I put a message box with the yes/no option. I am also trying to figure out how to write out a result one by one in an excel file. However, when I did the yes/no option (this is under an if statement), it would only seem to want to work on the first row.

Please let me know if I am on the right track!


HI @ktanli,

Please follow the Below Sequence, this might work!
Loop through all the Input data using for each
Message Box asking Yes/No to scrape data
If condition to check if it was Yes
in Then Part add Data Scraping Sequence
Next add an Excel application Scope
Use append range inside Excel Scope
Now close the Excel Workbook

Hope this helps!

1 Like