Custom Search
Home > Last Minute Training > Excel 2007 VBA Macros 2 Days- Presido Learning Center
Provided by: Last Minute Training

Excel 2007 VBA Macros 2 Days- Presido Learning Center

 Last Minute Training
Training Provided by Last Minute Training Location: Winnipeg Date: 2009-03-23 List Price: $550 Offered Price: $440. 00 Seats Available: 2 This course is intended for participants who are familiar with Excel 2000, 2002 or 2003. For information please call 1 877 313 8881 or visit http://www. lastminutetraining. ca/ courses. php/ course/ 6890/ Excel-2007-VBA-Macros-%282-Days%29
This is primarily ilt training
Contact Last Minute Training for more information
Course Level:basic
Duration:2 days
Training Presented in:English
Excel 2007 VBA Macros 2 Days- Presido Learning Center by Key Word

Narrow By Location
Choose a City Calgary City of Mississauga Edmonton Halifax Kitchener London Markham Mississauga Montreal Ottawa St. John's Teleseminar Toronto Town of Markham Town of Newmarket Vancouver Victoria Winnipeg


Excel 2007 VBA Macros (2 Days)
Location: Winnipeg Date: 2009-03-23
List Price: $550 Offered Price: $440. 00
Seats Available: 2










Presidio Learning Center Microsoft Excel, Word, Access training in Winnipeg Cancellation Policy

Description: This course is intended for participants who are familiar with Excel 2000, 2002 or 2003.

Upon completion of the course, participants will be able to accomplish the following:


Understand key concepts that will be used to build custom solutions using Microsoft Excel VBA Macros
Become familiar with basic macro techniques for recording, writing, running, and maintaining a macro
Understand how Visual Basic for Applications is incorporated, used, and modified in Microsoft Exce
Learn how to design and layout a user form and controls to create a customized dialog box tosimplify data entry
Understand how to prepare an Excel Workbook containing macros and toolbars, for deployment to other users and machines
Learn to customize macros with VBA source code to automate data entry tasks and enable source code protection
Learn to enhance source code with variables, constants, and logical operators
Learn to handle the three types of errors that can be generated when working with source code
Learn to access external data by using ActiveX Data Objects
Learn to use Excel as an automation server to control Excel objects externally outside of the application
Course Outline
Building Solutions
Course Overview
Solution Concepts
Data Entry Concepts
Macro Concepts
Programming Concepts

Macro Basics
Planning Macros
Recording Macros
Executing Macros
Maintaining Macros

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

VBA User Form Basics
Planning User Forms
Designing User Forms
Deployment Basics
Preparing for Deployment
Code Security
Creating Custom Toolbars
Creating Custom Macro Buttons
Attaching Toolbars

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

Enhancing VBA Code
Writing Source Code
Variables and Constants
Writing Tips
Logical Operators
Flow Control

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

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

Excel Automation
Automation Concepts
Working with Object Models
Excel s Object Model
Automating Excel with VBScript
About The Training Provider: Last Minute Training
Last Minute Training - Last Minute Training Corp. works similar to last minute discounted travel. We sell training seminars at deep discounts on a last minute basis. If you want to save 30 - 60 off high quality training seminars and have the flexibility to attend with only a few days notice check out our website and see if the training you are looking for is on sale. While your there set up and free account...
Home > Last Minute Training > Excel 2007 VBA Macros 2 Days- Presido Learning Center
Advertise With Us
Do you offer excel training?
tcw11-gfc-v396M-11/27/09-21:42:02-()[B]-[A]-[A] -15:51:13