Type: Business Professionals, Engineers and Scientists

Platform: Windows

Versions: 97-2007

Workshop Manual (Bus): Price and Buy

Workshop Manual (Eng & Sci): Price and Buy

Public Training: Review Our Workshops

Onsite Training: Details

Web Cast Information: Review Our Workshops

Workshop and Manual Overview

In this 2-day Visual Basic ActiveX DLL "hands-on" workshop, you will learn:

• VB ActiveX DLL development strategies for use with Microsoft Excel VBA applications
• VB ActiveX DLL project structure and content
• Object class, property and method design
• Microsoft Excel VBA project security using a VB ActiveX DLL
• VB ActiveX DLL linking with a Microsoft Excel VBA project
• ActiveX DLL compilation
• ActiveX DLL distribution

The Benefits of Using Visual Basic ActiveX Technology

Visual Basic ActiveX DLLs allow a business or engineer developer to construct and package their own custom objects then distribute them to other Visual Basic for Applications (VBA) or Visual Basic (VB) projects. Because a VB ActiveX DLL can be distributed, they help streamline the development of standardized Excel VBA tools and Visual Basic group tools and help create a uniform development environment for Visual Basic and Microsoft Excel VBA projects. They are also superb tools for creating procedure libraries for use on the Microsoft Excel worksheet. Most of all, they provide a secure environment in which to place your Microsoft Excel VBA project code preventing it from being viewed from outside parties.

Workshop Topics

Day-1 

• Object and class review
• Practical uses of objects
• Object method and property overview
• VB ActiveX DLL project overview
• ActiveX DLL creation
• Class module creation
• Object property design
• Object method design
• Object enum design

Day-2

• Object hierarchy design
• VB ActiveX DLL referencing from a VBA or VB project and distribution
• How to create and run objects from Visual Basic
• How to create and run objects from VBA via Microsoft Excel
• VBA ActiveX distribution

Workshop Materials

• The workshop manual contains helpful Excel VBA programming topics and code in a user-friendly format.
• The workshop manual illustrates Excel VBA topics using state of the art screen shots and 3-D graphics.
• Each workshop participant receives a comprehensive CD-ROM that contains the workshop examples and reading materials.

Who Should Attend

• Business, Engineers and Scientists with a solid understanding of how Excel VBA works.

EMAGENIT's Public Training Location

Public Location: Thousand Oaks, CA , LAX/Thousand Oaks

Hotel: Thousand Oaks Inn

EMAGENIT is based in Thousand Oaks, California which is in the vicinity of Los Angeles county (LA County), Ventura county, Santa Barbara county and San Diego county. We hold all of our on-site Microsoft Excel VBA courses nation wide. Our public workshops are a short commute for those living in the San Fernando Valley, Santa Clarita, Newbury Park, Camarillo, Calabasas, Sherman Oaks, Reseda, Woodland Hills, Hollywood, Fillmore, Ventura, Moorpark, Simi Valley, Santa Monica and Oxnard areas. For more information about our public workshops, visit our public workshops page our call us at the number above.