top of page

Introduction of VBA

Part 1 :-  VBA Introduction

Part 2 :-  My First Code

Part 3:- Buttons, toolbar

Part 4:- Selecting Cells, and Range

Part 5 :- Work sheet, chart and sheets
Part 6:- Workbook

Part 7:- Variable

Part 8:- Filter and shorting

Part 9:- Pivot Table

Part 10:- Massage and Input Box

Part 11:- with statement,  if statement and select case

Part 12:- Loops

Part 13:- Creating function

Part 14:- Error Heading

Part 15:-  Event Procedures

Part 16:- User Forms

Part 17:- Files and Folder

Part 18:- Array

Advance VBA

Please choose one of them or one by one

​

1. VBA- Pivot Tables Automation

2. VBA- Web Automation 

3. VBA- Outlook and MS Word Automation

4. VBA- Data Base (SQL, Access) Automation

5. VBA- Class Module

​

​

Click here to see Advance VBA

VBA- Pivot Table Automation

Part 1 :-  VBA Introduction

Part 2:- Pivot table Using Excel

Part 3:- Pivot Table using Access

Part 4:- Pivot Table using SQL

Part 5:- Power Pivot and Data Module

Part 6:- Pivot Chart

Part 6:- Pivot Slicers

Part 7:- Pivot Table Date filed and Time lines

VBA- Outlook and word

Part 1:- Introduction of Email Automation

Part 2:-  Create outlook email

Part 3:- Outlook email events

Part 4:- Create meetings

Part 5:- Outlook Email Using Word editors

Part 6:- Inserting picture in outlook email

Part7:- Copy email from the outlook

Part 8:- Referring a named outlook Folder

Part 9:- Looping through all outlook folder

Part 10:- Saving attachment from outlook folder

Part 11:- send and Receive Email from other outlook Account

Part 12:- Send email from a sharing mail ( like info@dokacademy.com)
Part 13:- Send email from specific Email

Part 14:- Create document using VBA

VBA- Class Module

Part 1:- Introduction – Class Module

Part 2:- Using Class Module in Other Project

Part 3:- Customer collection

Part 4:- Type Collection

Part 5:- Dictionaries  

VBA- Web Automation

Part 1:- Query web  page using Query Table

Part 2:- Browsing website and scripting

Part 3:- Login into website with window security 

Part 4:- Downloading file from website

Part 5:- Getting start with selenium 

Part 6:- Getting start with selenium with Google chrome

Part 7:- Using different web browser 

Part 8:- Finding web  element

Part 9:- Implicit and explicit waits

Part 9:- working with multiple Tabs

Part 10:- select Dropdown list

Part 11:-Copy a CSV data from web

Part 12:- Open google chrome with user profile

Part13:- Google Translate using vba

VBA- Data Base

Part 1:- Introduction – ADO (ActiveX Data Object)
Part 2:- ADO – Modify data with records

Part 3:- ADO – SQL Statement (Insert , Update, Delete)

Part 4:- Pivot Table Using Access data base

Part 5:- Pivot Table Using SQL data base

Part 6:- Connect to SQL Server using ADO and the MSOLEDBSSQL Driver

Part 7:- Get data from SQL server with ADO records

Part 8:- Read and execute SQL Files

Part 9:- Return Multiple result set from SQL Query

Part 10:- Basic ADO Commends

bottom of page