VBA-200
VBA SOLUTIONS

*Prerequisite*
VBA-100: VBA Foundations

What past students had to say about this class:

Great class. the information will be very useful.~J.M. \Zimmer Dental

This course will teach to to start thinking in terms of how you can make your work life simpler. This course gets you going in VBA by showing you the tools to start automating little tasks right away. 

Audience: Programmers who will be developing in VBA 6

Course Content:  

Exploring the Object Models of the Office Products

·         Figuring Out Object Models

·         Working with the Object Browser: Microsoft Access

·         Knowing the Interactive Product: Microsoft Word

·         Mining the Help File: Microsoft Excel

 Working with Active Objects

·         Active Properties in Office

·         Excel’s Active and Selection Properties

·         Word’s Active and Selection Properties

·         The Access Screen Object

 Using Another Product’s Features with Automation

·         Expanding Your Horizons Using Automation

·         Getting to the Object Model

 Working with Data Using ADO

·         Introducing ActiveX Data Objects

·         Working with Data in Recordsets

·         Moving Through a Recordset

·         Creating a Recordset Based on a SQL String

·         Adding a Recordset to a Worksheet

 Advanced User Form Techniques

·         Restricting User Entry

·         Using List Boxes and Combo Boxes

·         Creating a Tabbed Dialog Box

·         Additional ActiveX Controls

 Techniques with VBA Variables

·         Scope, Lifetime, and Precedence

·         Passing by Value and by Reference

·         Optional Arguments

·         Creating Your Own Collections

Adding Data to Excel, Access, and Outlook

·         Using VBA to Work with Data

·         Adding Values to an Excel Worksheet

·         Adding ADO Data to Excel

·         Adding a Database Record with ADO

·         Adding an Item to Outlook

Adding Content to Word and PowerPoint

·         Adding Text to a Word Document

·         Adding Content to PowerPoint

Charting Your Data

·         Excel's Chart Object

·         Creating a Chart

·         Creating an Excel Chart from Access

Giving Your Solutions to Others

·         Sharing the Wealth

·         Using Custom Toolbars

·         Office Templates and Add-Ins

·         Securing Your Code

·         Using Microsoft Office 2000 Developer to Deploy Solutions