In this course, we’ll delve into the more intricate aspects of VBA programming to elevate your Excel automation skills. This course goes beyond the basics to explore class modules, collections, and dictionaries, providing you with the tools to create sophisticated, reusable code and manage complex data structures efficiently. You’ll gain expertise in designing custom classes, handling multiple data types, and implementing advanced programming concepts to build robust, scalable solutions. With hands-on projects and real-world examples, you’ll learn to harness VBA’s full potential, enabling you to tackle complex automation tasks and streamline your workflows with precision and flexibility.
Experienced VBA Users: If you already have a good understanding of VBA and want to elevate your skills, this course will help you leverage class modules, collections, and dictionaries to create more sophisticated and reusable code
Pre-requisites
Curious to Learn
Willingness to Practice
Good understanding of VBA
Course content
IMPORTANT: Currently we are re-desiging all our courses and latest syllabus will be available as soon as it is ready.
1.What Is D-Approach In Programming?
Developer As User
Developer As Hidden User
Developer As Developer
What Approach Should A Developer Follow While Creating A Program
2.Working With Names
Creating Names To Store And Use Important Data
Creating Hidden Names
Creating Names To Store Array
Advantages & Dis-Advantages Of Using Name
3.Working With Registry
Using Registry To Store And Retrieve Data
Advantages & Dis-Advantages Of Using Registry
4.Working With Collection
Using Collection To Store Multiple Values
Working With Key In Collection
Using Collection To Get Unique Data
Using Collection To Get Unique Data Based On Multiple Headers
Using Multiple Key Combination In Dictionary
Advantages & Dis-Advantages Of Using Collection
5.Working With Dictionary
Using Dictionary To Store Multiple Values
Working With Key In Dictionary
Using Dictionary To Get Unique Data
Using Dictionary To Get Unique Data Based On Multiple Headers
Using Multiple Key Combination In Dictionary
Advantages & Dis-Advantages Of Using Dictionary
6.Difference Between Collection And Dictionary
Benefits Of Collection Over Dictionary
Benefits Of Dictionary Over Collection
7.Creating & Working With Custom Classes
Creating Enumerable Classes
Creating Object Class
Creating Collection Classes
Creating Custom Class Properties
Creating Custom Class Events
Creating Custom Class Methods
Advantages And Dis-Advantages Of Using Custom Classes
Using Custom Classes For Robust Programming
Creating Reusable Custom Classes
Using Custom Classes Across Multiple Projects
Using Custom Classes For Faster Programming
Using Custom Classes For Reducing Programming
Using Custom Classes For Error Handling
8.Working With File System Object
Using FSO To Create Text File
Using FSO To Import Data From Text File
Using FSO To Create Zip Files
Using FSO To Loop In All Directories Within Directories
9.What Is Recursion?
When Should We Use Recursion?
Creating Recursion Methods
10.Binding
What is Binding?
What Are Types Of Binding? (Early Binding And Later Binding)
Advantages And Dis-Advantages Of Using Early Binding
Advantages And Dis-Advantages Of Using Late Binding
11.Working With Web Applications
Connection To Internet Using VBA
Inserting Data On Website
Fetching Data From Website
Fetching Stock Data
Login To Google
Working With Various Website
Using ID, Tag, Class, Position To Get Element
12.Dynamic Add-Ins
Creating Dynamic Add-Ins
Benefits Of Using Dynamic Add-Ins
13.Types Of Classes
P-Class
PBNC-Class
GMU-Class
MU-Class
14.Working With VB6
What Is DLL (Dynamic Link Library)?
Creating Custom DLL
Using Custom DLL
15.Working With User Forms
Creating Dynamic User Forms
Using Collection & Object Class To Build Robust User Form Application