VBA for Microsoft Office Level 2 Course

Upon completion of this course, the participant will be able to:
> Create their own application to e-mail sales figures or even spreadsheets and graphs to the right people each morning by clicking one button
> Verify data entered in an Excel spreadsheet against tables stored in Microsoft Access
> Use a Microsoft Access database to keep track of what correspondence has been sent to whom without leaving Word
> Create a PowerPoint presentation automatically from an Access report and an Excel chart

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

Appendix Topics (Covered as time permits.)
VBA Naming Conventions Resources