VBA Macro Automation

  • Introduction of VBA & Macro.
  • Introduction of all Types of Windows (Properties Window, Project Window, Code Window, Local Window, Watch Window, Immediate Window)
  • Introduction of Sub & Function Procedure
  • Naming of Procedure
  • Write Our First Code.

Working With Variable & Data Types

  • Introduction of Variable & Data Types.
  • Naming of Variable
  • Introduction of Object Variable.
  • Set the Object Variable – Workbook Object, Worksheet Object, And Range Object
  • Introduction of Public And Private Declaration.
  • Introduction of Static Declaration.

Working With Workbook Object.

  • Introduction of Thisworkbook And Activeworkbook
  • Add Workbook
  • Delete Workbook
  • Rename Workbook.
  • Save Workbook In Different Format (.Xlsx, .Xlsm, .Xls, .Xlsb, .Xltx, .Xltm, .Xlt, .Pdf And Many More)
  • Create Workbook Object
  • Other Automation

Working with Worksheet Object.

  • Add Worksheet
  • Delete Worksheet
  • Rename Worksheet
  • Create Worksheet Object
  • Move or Copy The Worksheet to Another Workbook.
  • Activate Worksheet.
  • Other Automation

Working With Cells & Range Object.

  • Create Range & Cells Object
  • Highlight Cells & Range
  • Copy & Paste
  • Find the Last Column & Row.
  • How to Activate Cells
  • Goto Special.
  • Cell Formatting & Number Formatting.
  • Sort & Filter.
  • Find & Select.
  • Basic & Advanced Filter.
  • Hyperlink.
  • Print Excel Sheet.
  • Other Automation

Error In VBA.

  • All Types Of Error In VBA (Application-Defined Or Object-Defined Error, Object Doesn’t Support This Property Or Method)
  • All Types Of Error Handler Using In VBA Ex. On Error Resume Next, On Error Goto 0 And Label.

Application, Worksheet & VBA Function

  • Vlookup, Hlookup, Countif, Countifs, Match, And Other Functions.
  • Using If, Iif, Switch, And, Or, Like, Goto Statement, And Select Case In VBA Syntax.

VBA Protection & Security

  • Workbook, Worksheet, Range, and Object Protection
  • VBA Project Protection, and Password Breaker

Event

  • Worksheet Event (Activate, Change, Selection, Deactivate And Other Event)
  • Workbook Event (Activate, Open, Close And Other Event)

Array

  • Static Array.
  • Dynamic Array.
  • Single And Multi-Dimension Array.
  • Live Array VBA Projects.

Loop In VBA

  • For Next Loop
  • For Each Loop
  • Do Loop/ Do While/ Do Until
  • Nested Loop
  • Excel Based Automation Projects Based On Queries

Pivot Table & Pivot Chart

  • Create A Pivot Table From VBA.
  • Create Chart From VBA.

File Folder Management.

  • Using Late Binding & Early Binding Methods In VBA Projects.
  • Using Microsoft Scripting Runtime For Manage Folder And File.
  • Rename Folder, Create Folder And Delete Folder.
  • Rename File, Create File, Delete File, And Move File To One Folder To Another Folder.
  • Looping Over Folder And File.
  • Using File Dialog Box.
  • Using File & Folder Pickers.
  • Extract File Name From Folder With Using Dir Function

Udf (User Defined Function)

  • Create Many Types Of Udf Function For Calculation.
  • Create Volatile & Non-Volatile Function.

User Form

  • Create User Form By Using The VBA Code.
  • Creating Custom Dialogue Box In Userform
  • Using All Types Of Control In User Form(Combobox, Listbox, Checkbox, Optionbutton.

Creating A Word Document

  • Referencing The Word Object Library.
  • Using Late Binding And Early Binding Method For Creating A New Instance Of Word.
  • Save Word Document In Different Format (.Docx, .Docm, Doc, And Pdf)
  • Copy Data And Chart Into Word
  • Writing And Formatting Text.

Creating Outlook Emails

  • Referencing The Outlook Object Library.
  • Using Late Binding And Early Binding Method For Creating A New Instance Of Outlook.
  • Opening An Outlook Application And Creating A New Mail.
  • Send Email From Outlook With A Signature From VBA
  • Send Emails From Outlook From VBA With Attachment.
  • Looping Over Sending Emails.
  • Creating Outlook Event.

Creating A Powerpoint Presentation

  • Referencing The Powerpoint Object Library.
  • Using Late Binding And Early Binding Method For Creating A New Instance Of Powerpoint.
  • Creating Presentation & Slides.
  • Copying Tables & Charts Into Powerpoint.
  • Adding And Formatting Textboxes.

Working With Ms Access And Excel

  • Referencing The Ms Access Object Library.
  • Using Late Binding And Early Binding Method For Creating A New Instance Of Ms Access.
  • Create Table.
  • Import And Export Data In Ms Access To Excel.
  • Using Sql Query In VBA
  • Using Some Objects For Ms Access In Excel.

Adodb Method (Microsoft Activex Data Object 6.1)

  • Create A Connection Between Sql Server And Excel By Using Adodb.
  • Using All Types Of Sql Cursor In VBA.
  • Create Table, Drop Table In Sql Server Using VBA.
  • Import & Export Data From Sql Server.
  • Modifying Data, Inserting Data.
  • Using Sql Stored Procedure In VBA.

Web Crawling

  • Web Crawling With Browser Internet Explorer.
  • Creating Html Document.
  • Understanding The Html Tags And Use Them For Crawling
  • Fetch the data from HTML Document
  • Using Get And Post Request In Crawling
  • Using All Types Of Web Elements.

Add-Ins And Custom Ribbons

  • Understanding of XML Code
  • Creating Add-Ins And Custom Ribbon For Excel.
  • Creating Add-Ins And Custom Ribbon For Word.
  • Creating Add-Ins And Custom Ribbon For Powerpoint.