This post is to give small tip related to web scraping. If you are new to web scraping please see my earlier post which explain everything from beginning. Below is the link to that post.
Web Scraping - BasicsIn this post I will explain you what are the best VBA references you should add when you develop a Visual Basic Application to scrape data from websites. Adding these references are not mandatory. But it will make your life easier. So here are the list of useful references.
- Visula Basic for Applications
- Microsoft Excel 15.0 Object Library
- OLE Automation
- Microsoft Office 15.0 Object Library
- Microsoft Forms 2.0 Object Library
- ietag 1.0 Type Library
- iextag 1.0 Type Library
- Microsoft HTML Object Library
- Microsoft Internet Controls
As you can see that there are numbers like 15.0 etc. These numbers can vary according the versions you have installed in your computer.
Also when you open your VBA editor you will notice that first four items of the list are automatically ticked by default. So you don't need to add them manually.
And when you insert form for the first time to your project, VBA editor will automatically add reference to Microsoft Forms 2.0 Object Library. So you also don't need to worry about adding the reference to that library.
Ultimately you have shorter list to add references manually. Here is that list
- ietag 1.0 Type Library
- iextag 1.0 Type Library
- Microsoft HTML Object Library
- Microsoft Internet Controls
Once you add references, your references window should look like this.
