This course is provided by Wintrac. Wintrac
provides one stop shopping for all your IT training needs. Wintrac’s course
catalog of over two thousand courses includes courses on Visual Basic
Training
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
Please contact your training representative for more details on having this course delivered onsite or online
