How to add VBA References – Internet Controls, HTML Object Library

In order to control the Internet Explorer web browser, VBA needs 2 additional reference libraries:

Microsoft HTML Object Library   and   Microsoft Internet Controls

 
 

Here’s how to add them…

Open the VBA Editor, and click Tools > References…

Visual Basic Editor - Tools > References
Visual Basic Editor – Tools > References

Make sure these 4 References are active by default:

  • Visual Basic for Applications
  • Microsoft Excel xx.x Object Library
  • OLE Automation
  • Microsoft Office xx.x Object Library
VBA default reference libraries
VBA default reference libraries

Scroll down a tick these 2 web-related References:

  • Microsoft HTML Ojbect Library
  • Microsoft Internet Controls
Add MS HTML Object Library, MS Internet Controls
Add MS HTML Object Library, MS Internet Controls

Resulting in…

VBA - Needed references for building web bots
VBA – Needed references for building web bots
Facebooktwittergoogle_plusredditlinkedintumblrFacebooktwittergoogle_plusredditlinkedintumblr