To connect to HTML page through VBA , HTML object Library and Microsoft Internet Controls should be added to References. Below is the steps to add the references :

• Go to Developer tab and click on Visual Basics

• Once below screen opened .Go to the tools tab.

• Right click on Tools and go to references.

• It will give the list of the references available .Now search  HTML object Library and Microsoft Internet Controls  and check in the check box.

 Hope this will help you ...........