Course code Title Language Price # Unit Startdate Hour Enddate Location Signup
MSVIC04 Excel Pro Developers VBA Course program for 2003 – 2010 on your request on your request Contact Us

Excel Pro Developers VBA Course program for 2003 – 2010

Excel Pro Developers VBA Course program for 2003 – 2010

Overview

Course code: 
MSVIC04
Duration: 
1
Time Unit: 
Day(s)
Overview: 

This is the next step in VBA programming. If you have a complicated Excel automation project to handle. Classes are used to make your programming map the business more. You can make a Client or Report object that carries information and functionality inside like print, send, classify etc.
A dedicated Excel solution needs a good presentation. In this case the ribbon can help you to do that. We are defining the ribbon using a text based xml file.

Topics

Topics: 

1. Programming Types & Enums in VBA (e.g. use in select case)
2. Programming Classes in VBA (define – instantiate)
3. ByRef and ByVar parameters situation
4. File Management in VBA (optional)
5. Customize Toolbars/ Ribbons/ Backstage (for 2007/2010)
6. Full XLA Add-In Packaging

Prerequisites

Prerequisites: 

Having followed the previous Advanced VBA Course (MSVIC03)
People having a good idea of the usage of sub’s and functions and parameters in VBA

Audience

Audience: 

Developers who want to program with Types, Enums and Classes
Excel users who want to present their solutions using the Ribbon