If you need a macro to run a very long time (hours, days or even weeks) I recommend that you start it from the command line. This way you have full control over the browser and ui.vision.
If that happens, I recommend to loop the extracting in your calling script. So you would write a macro that e. g. extracts 1000 lines at once, and then stops.
Now your calling script closes the browser & ui.vision and then starts both fresh for the next 1000 lines. Do this 100 times and your web scraping is completed.
You find sample code for Node.JS, Python, Powershell etc here: RPA/command-line at master · A9T9/RPA · GitHub