Add Microsoft Html Object Library Reference
To make the macro work with an external source such as a webpage, we’ll need Microsoft’s Internet Explore (to open the page and will remain hidden). In-addition, to read and extract contents of Html elements, we’ll have to create few objects using a library.
Therefore, first add the Microsoft Html Object Library reference to the application. From the top menu of your Vba editor, click Tools -> References…. In the References window, find and select Microsoft Html Object Library and click OK.