I heavily use VBA to scrape websites. Although I have dabbled in other methods, for now I am still sticking mainly with automating the Internet Explorer browser (Yes, I am aware that this is the slowest method to get data from the net. However it is the easiest to write and you can see immediately if something goes wrong).
The purpose of this thread is to optimise the browser automation code that I am using.
Attached is a workbook containing the class that I use for website scraping. The procedures were adapted from various websites/forums + some I nutted out myself. (If I have overlooked crediting anyone, please let me know)
I expect there will be many amateur mistakes as I have never learnt HTML (I aim to do a course later this year). I am not stupid, just lacking knowledge & experience!
UPDATE: Cancelling this thread and removed workbook
Bookmarks