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.