What You'll Learn

• Learn key concepts to build custom solutions using Microsoft Excel VBA Macros
• Learn basic techniques for recording, writing, running, and maintaining a macro
• Understand how VBA is incorporated, used, and modified in Microsoft Excel
• Design and lay out a user form and controls to create a customized dialog box to simplify data entry
• Prepare an Excel Workbook containing macros and toolbars, for deployment to other users and machines
• Customize macros with VBA source code to automate data entry tasks and enable source code protection
• Enhance source code with variables, constants, and logical operators
• Handle three types of errors that are generated when working with source code
• Access external data by using ActiveX Data Objects
• Use Excel as an automation server to control Excel objects externally outside of the application

Course Outline

1. Building Solutions

• Course Overview
• Solution Concepts
• Data Entry Concepts
• Macro Concepts
• Programming Concepts

2. Macro Basics

• Planning Macros
• Recording Macros
• Executing Macros
• Maintaining Macros

3. VBA Programming Basics

• Understanding Objects
• Using the Visual Basic Editor
• Understanding VBA Code
• Executing VBA Code
• VBA Help Reference

4. VBA User Form Basics

• Planning User Forms
• Designing User Forms

5. Deployment Basics

• Preparing for Deployment
• Code Security
• Creating Custom Toolbars
• Creating Custom Macro Buttons
• Attaching Toolbars

6. Customizing Macros

• Prompting for User Input
• Automating Data Entry
• Recording Absolute vs. Relative References
• Protecting VBA Source Code

7. Enhancing VBA Code

• Writing Source Code
• Variables and Constants
• Writing Tips
• Logical Operators
• Flow Control

8. Handling Errors

• Handling Errors
• Syntax Errors
• Logical Errors
• Run-Time Errors

9. Accessing External Data

• External References
• ActiveX Data Objects Concepts
• Connecting to a Database
• Retrieving Records from a Database

10. Excel Automation

• Automation Concepts
• Working with Object Models
• Excel's Object Model
• Automating Excel

Classroom Dates and Locations

Date	Location
Sep 21 - 22, 2010	Toronto, ON	Register
Sep 30 - Oct 1, 2010	Winnipeg, MB	Register
Oct 4 - 5, 2010	Victoria, BC	Register
Oct 14 - 15, 2010	Mississauga, ON	Register
Oct 20 - 21, 2010	Ottawa, ON	Register
Oct 26 - 27, 2010	Calgary, AB	Register
Nov 2 - 3, 2010	Toronto, ON	Register
Nov 15 - 16, 2010	Edmonton, AB	Register
Nov 16 - 17, 2010	Montreal, QC	Register
Nov 22 - 23, 2010	Kitchener, ON	Register
Nov 24 - 25, 2010	Vancouver, BC	Register
Dec 13 - 14, 2010	Mississauga, ON	Register
Dec 22 - 23, 2010	Toronto, ON	Register
Jan 17 - 18, 2011	Winnipeg, MB	Register
Jan 17 - 18, 2011	Victoria, BC	Register
Jan 17 - 18, 2011	Ottawa, ON	Register
Jan 17 - 18, 2011	Halifax, NS	Register
Jan 19 - 20, 2011	Calgary, AB	Register
Jan 24 - 25, 2011	Vancouver, BC	Register
Jan 24 - 25, 2011	Montreal, QC	Register
Feb 7 - 8, 2011	Mississauga, ON	Register
Feb 14 - 15, 2011	Edmonton, AB	Register
Feb 16 - 17, 2011	Toronto, ON	Register
Feb 28 - Mar 1, 2011	Winnipeg, MB	Register
Mar 3 - 4, 2011	Kitchener, ON	Register
Mar 14 - 15, 2011	Calgary, AB	Register
Mar 29 - 30, 2011	Toronto, ON	Register
Apr 4 - 5, 2011	Vancouver, BC	Register
Apr 5 - 6, 2011	Ottawa, ON	Register
Apr 11 - 12, 2011	Victoria, BC	Register
Apr 11 - 12, 2011	Montreal, QC	Register
Apr 18 - 19, 2011	Mississauga, ON	Register
Apr 26 - 27, 2011	Edmonton, AB	Register
May 2 - 3, 2011	Winnipeg, MB	Register
May 11 - 12, 2011	Calgary, AB	Register
May 19 - 20, 2011	Toronto, ON	Register

Don’t see the location or date you need? No problem – just use our By Request service.