VBA Macro Programming & Automation
-
Macro Recording and Running
-
Programming Concept
-
Developer Tab and Menu
-
Recording a Macro
-
Saving Macro in Different Workbooks
-
Various Methods of Running a Macro
-
Command Button
-
Design Mode
-
Running Mode & Break Mode
-
Modules and Procedures
-
Absolute and Relative Reference
Introduction to Visual:-
-
Basic Editor
-
Project Explorer and Code Window
-
Modules
-
Functions and Subroutines
-
Worksheet Properties in Property Window
Programming Basic
-
Public and Private Subroutines
-
Object
-
Methods and Properties
-
Object Hierarchy & Collection
-
Creating a Folder/Subfolder
-
Opening , Saving, Closing New Workbook
-
Opening a saved Workbook
-
Selecting/Activating/Renaming/Adding Sheets
-
Range, Cells, Columns & Row Properties
-
Writing a Simple Code in VBA
Variables and Data Types
-
VBA Data Types
-
Variables and Constants
-
Numeric and String Types
-
String and Date
-
Boolean, Long, Integer, Byte, Double, Single, Currency
-
Working with Arrays
-
Working with Arrays
-
Single line Decision
-
Nested Line Decisions
-
Single Line Case
-
Nested Line Case
-
IIF, If and Then Statements
-
IIF, If and Then Statements
-
Looping -
-
DoLoop, For Next Loop , For Each Loop
-
Data Compilation
-
Conditional Data Compilation
-
Conditional Sheet Add
-
Looping through Object
-
Looping Sheet
-
Looping Workbook
-
Looping file & Folders
-
While Wend Loop
-
Do Until Loop
-
Some Useful Formula Using Loop
Dialog Boxes and User Form
-
Massage Box
-
Input Box
-
Using Loop in Input Box
-
Selecting User defined range in Input box
-
Creating a User Form
-
Label, Text Box, Combo Box, List Box
-
Check Box Option Button
-
Spin Button, Command Button
-
Frame
Using Excel Application and Function
-
Sorting and Filtering Data Using VBA
-
Creating Pivot Table Using VBA
-
Text to Column
-
Remove Duplicate
-
Formatting
-
Protecting/Unprotecting a Sheet Using VBA
-
Using Excel Formulas like V-lookup
-
H-lookup and other functions in VBA
-
Import Text/CSV files using VBA
Outlook & PPT Automation
-
Connecting with Microsoft Outlook
-
Creating Outlook New Session
-
Early Binding and Late Binding
-
Formatting HTML and Plain/Rich Text Body
-
To, CC, BCC, Subject ,Body Text & Signature
-
Attach a file in Email using VBA
-
A Simple Programme of Email
-
Automate Multiple Mails