VBA Solutions For Microsoft Office - Level 2
Visual Basic Training Overview
VBA for Microsoft Office courseware will teach you to start thinking in terms of how you can make your work life simpler. This courseware gets you going in VBA by showing you the tools to start automating little tasks right away.
Visual Basic Training Prerequisites
VBA Foundations for Microsoft Office - Level 1.
Visual Basic Training Audience
Programmers who will be developing in VBA6.
Visual Basic Training Course duration
2 Days
Visual Basic Training Course outline
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
- Working With the ADO Command Object
- 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 Developer 2000 to Deploy Solutions
