I'm using one Excel file to create a variable to loop through web pages to scrape the data and another Excel instance to write the data. Both working.
BUT what I need help is I need to get data from the active cell in ExcelInstance CurrentItem and paste it into ExcelInstance2 at the beginning of each data scrape in the loop as I need to know what Asset Name the returned scraped data belongs to. Is there a Get Cell Write Cell option to handle this?
Also I get an ERROR when the last URL cell is empty which stops the flow.
Can I simply implement another On Block Error loop to force it to save the ExcellInstance2 and stop the flow?
Paul


Report
All responses (
Answers (