VBA MACRO AUTOMATION

  • Introduction of vba & macro.
  • Introduction of class, object, properties, methods.
  • Introduction of all types of Windows(Properties Window, Project Window, Code Window, Local Window, Watch Window, Immediate Window)
  • Introduction of variable & data types.
  • Introduction of Public and Private Declaration.
  • Introduction of Static Declaration.
  • Using Late Binding & Early Binding methods in VBA Projects.
  • VBA Security and Protection.

Basic & Advance automation with vba & macro.

  • Save file in different format (.xlsx, .xlsm, .xls, .xlsb, .xltx, .xltm, .xlt, .pdf and many more).
  • Paste special.
  • GoTo special.
  • Cell formatting & number formatting.
  • Sort & filter.
  • Find & select.
  • Basic and advanced filter.
  • Hyperlink.
  • Print Excel Sheet.

Working with Cells & Range.

  • Highlight Cells & Range
  • Copy & Paste
  • Find the last Column & Row.
  • How to activate cells
  • Other automation

Working with Worksheet.

  • Add Worksheet
  • Delete Worksheet
  • Rename Worksheet
  • Move or Copy Worksheet to another workbook.
  • Activate Worksheet.
  • Other automation

Working with Workbook.

  • Add Workbook
  • Delete Workbook
  • Rename Workbook.
  • Introduction of ThisWorkbook and ActiveWorkbook
  • Other Automation

Event

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

Application, Worksheet & VBA Function

  • VLookup, Hlookup, Countif, Countifs, Match, and Other function.
  • Using IF, IIF, Switch, Select Case in VBA syntax.

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.

Loop in VBA

  • For Next Loop
  • For Each Loop
  • Do Loop/ Do While/ Do Until
  • While Wend
  • Nested Loop

Pivot Table & Pivot Chart

  • Create a Pivot Table from VBA.
  • Create Chart from VBA.

File Folder Management.

  • 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 Define Function)

  • Create many types of UDF function for calculation.
  • Create Volatile & Non-Volatile Function.

Array Function

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

Creating Word Document

  • Referencing the word object library.
  • Using Late binding and Early Binding method for Creating a new instance of Word.
  • Copy data 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 email 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 & Chart 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 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 and without Browser.
  • Using Internet Explorer for Web Crawling.
  • Using all types of Web Elements.

User Form

  • Create User Form by using VBA code.
  • Run multiple programs at a time by User Form.
  • Using all types of control in User Form(ComboBox, ListBox, CheckBox, OptionButton.

Add-Ins and Custom Ribbons

  • Creating Add-Ins and custom Ribbon for Excel.
  • Creating Add-Ins and custom Ribbon for Word.
  • Creating Add-Ins and custom Ribbon for PowerPoint.

Course duration & fees.

Learn Advance Excel

4 Months (Sat or Sun – 2 Hours, Morning Class 9:00 AM to Evening 7:00 PM) online classes.

 Fees: – 8000 INR/

 Class Videos, Notes, PDF Books

VBA MACRO AUTOMATION

Online Training in Advanced VBA Macro