Web Page Automation: Automation using VBA - Initial Setup

In this post of Web Page Automation blog, we will see how to do intial setup required to automation web application using VBA and selenium

Setup Requirement:

• Selenium Wrapper for VBA 
• Microsoft Excel
• Chrome Browser
• Chrome WebDriver (Version that supports the browser)

Note: VBA - Visual Basic for Application which is using Microsoft Excel for developing software/codes/macros

Getting Selenium Wrapper for VBA

1. Navigate here and download the latest Selenium Wrapper

Example: Download SeleniumBasic vX.X.X.X or Download the .exe version as highlighted below

2. Install downloaded Selenium file by double clicking on the exe file

Microsoft Excel: 

Hope you have it installed else to purchase it from Microsoft site 

Chrome Browser: 

1. Install Chrome browser from  here
2. Note the version number of the chrome browser by going to 'Customize and Control Google Chrome>Help>About Google Chrome'

Chrome Web Driver

1. Navigate http://chromedriver.chromium.org/downloads and download the compatible driver

2. In the next page download windows version zip file

3. Unzip the Chrome driver and copy the Chrome.exe from the folder and paste it into the 'Selenium Wrapper' installation folder  C:\Users\XXX\AppData\Local\SeleniumBasic

Initial setup for web page automation using VBA and Selenium is completed!