Cal

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!

Web Page Automation: Using Excel Sheet

Web Page Automation using Microsoft Excel Sheet

What is VBA?

VBA: Hello world

Open Web Browser

Enter Data in Web Page

Click button in Web Page

Read Data from Web Page

Close Web Browser

Web Page Automation : Introduction

Web Page Automation

This blog post covers the existing web page automation process and techniques. It targets individuals who are interested in automation or need to learn how to automate a web page. 

Web page automation replaces human with programming for monotonous and repetitive errands, for example, 

1. Form filling
2. Screen scratching
3. Information extraction and exchange between applications
4. Site testing
5. Periodical report

Many organization and individuals started seeing the advantage of web page automation. Below are few of the examples of such automation

Organizations use web page automation to simulate the end user experience and test it. Example, banks use automation to test online banking experience

Even other individual users use automation for

1. Scrapping the web page data
2. Youtube video share automation
3. Facebook automation auto likes, add friends etc
4. Other social media automation
5. Automate web page functionalities