HTML scraping with a help of Selenium

Hello all,

I currently got a VBA code with elements of Selenium which helps me to return web data into the sheet where I can use it to generate pivot table. Currently this code to return data has to open web browser and click individual list object. I'm new with selenium so I am wondering if it is possible to optimise this code so the web browser doesn't need to be open or any other suggestions improve run time are appreciated.

Please Login or Register  to view this content.

Capture.PNG

Ok if you want web browser invisible you can use PhantomJs.

Please Login or Register  to view this content.