Advanced VBA Training

Course Features

Module 1- Links to other applications

1. Referencing other applications
2. Instantiating objects
3. Writing inter-application code

Module 2 - File System Objects

1. Referencing File System Objects
2. Working with files and folders

Module 3 - File Dialogs

1. Using File Dialogs
2. Allowing multiple selection

Module 4 - Working with text files

1. Avoiding using INPUT/OUTPUT
2. Reading and writing text files

Module 5 - Linking to data (*)

1. ADO or Access Database Engine
2. Referencing the right library
3. Opening and using recordsets

Module 6 - Arrays

1. Creating and populating arrays
2. Dynamic arrays
3. The PRESERVE keyword

Module 7 - Passing arguments

1. ByRef and ByVal
2. Using optional arguments
3. Using Param Array

Module 8 - Advanced programming ideas (*)

1. Using functions in code
2. Recursive programming
3. Enumerations

Module 9 - Working with shapes (*)

1. Adding shapes
2. Positioning shapes
3. Formatting shapes

Batches Details

Regular Batch: 15-18 Sessions* (1.5hrs)

Weekend Batch:: 12-13 Sessions*(2hrs)

Fast Track: 03-05 Days*(3.5hrs)

ELIGIBILITY :

12th+ Having basic knowledge of Computer

Fees : Call Us For Best Discount and Offers

TALK TO US






PROFESSIONAL COURSES

What Our Student Says