Visual Basic ActiveX DLL Design for Engineers, Scientists and Business Professionals Workshop Outline

Our "program connectivity" Microsoft Excel VBA workshop that shows you how to secure your VBA code in Visual Basic 6.0 and Visual Basic .Net and also use the resources of those languages to enhance your VBA code. Read below and see how to enhance your VBA programs>>>

Call us at:   1.805.498.7162     1.805.558.9277--

Learn about how we can help your company or yourself achieve your Microsoft Excel training or self-study goals Visit our free Microsoft Excel and Microsoft Excel VBA resource center Learn how we can help save your company money with our innovative software solutions Visit out VBA code center for code that can save your company money Learn about our Excel Add-In software that can save your company time and money View our customer list from our 12 years in business Phone numbers, request form and email address Learn about EMAGENIT View our training schedule for Microsoft Excel and Microsoft Excel VBA

NASA Award for Microsoft Excel Design

EMAGENIT received an award from NASA for its software design in Microsoft Excel and VBA for the Mars Rover. We provide training for customers like AMGEN, General Dynamics and Caterpillar. Read below to learn more about our Beginning VBA Training.
 

Workshop Availability
  • Onsite, Self-Study*, Public*, Webinar*

*Advanced VBA covers the same basic material in a less focused format. Click here for business. Click here for engineering and science.

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.

What You Learn at a Glance

  • 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

Workshop Information

  • 2-day workshop

  • Personal examples: Covered in-class

  • Excel Versions: 2000-2010

  • Type: Business Professionals, Engineers and Scientists

  • Platform: Windows

  • Training Materials: Included, 1800+ page manual including our Excel Add-Ins

  • Training Method: Hands-on

Workshop Outline

In this 2-day"hands-on" workshop you will learn:

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

Intended Audience

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

Information Request

Submit a question to us via email at actx@emagenit.com

Call EMAGENIT between the hours of 8:00 A.M. and 5 P.M. PST at 1.805.498.7162 or 805.558.9277 for more information about this workshop.
Newsletter Contact Us Training Help
 

 

 

Additional Pages

Microsoft Excel Classes  Microsoft Excel VBA Courses  Microsoft Excel Training  Microsoft Excel Macros  Microsoft Excel VBA Consulting  Microsoft Excel Add-Ins

Copyright © 2002-2011 EMAGENIT All Rights Reserved