Call on 1300 794 006 Advanced Search

Home > Desktop Applications > Microsoft Word > Microsoft Word 2007

VBA Word 2007 Book a course:   Location: Sydney Melbourne Brisbane Date: Choose a date... 27 Jun 12 - 29 Jun 12 30 Oct 12 - 01 Nov 12 {None} 9:00 AM - 5:00 PM 9:00 AM - 5:00 PM   Duration: 3 Days Time: 9:00 AM - 5:00 PM   Price: $1,650.00 inc. GST Print Preview | Send to a friend    Learning Method: Instructor Led Duration: 3 Days Overview: The skills and knowledge acquired in Microsoft Word 2007 Programming in VBA are sufficient to be able to create VBA applications in Microsoft Word 2007. Target Audience: Microsoft Word 2007 Programming in VBA is designed for people who need to know how to program applications for using Visual Basic for Applications. Pre-requisites: This publication assumes some familiarity with the features and capabilities of Word 2007 and it would be beneficial to have a general understanding of personal computers and the Windows operating system environment. At Course Completion: After completing this course, students will be able to: Understand the Word object model and VBA concepts Work with the three main components of the VBA Editor window Create command procedures Create and use variables Create and work with functions Use decision structures to control the outcomes of your program Use looping structures to repeat sections of code Work with text using a range of objects Customise the ways in which files and folders are managed Create a custom form complete with controls and event procedures Create code to drive a user form Write a variety of error handling routines Use Word’s built-in dialog boxes Outline: Expand All Module 1: Understanding VBA VBA Terminology About Objects The Object Hierarchy Accessing the Word Object Model Using the Immediate Window Working with Object Collections Setting Property Values Module 2: Using the VBA Editor The VBA Editor Opening and Closing the Editor Working With the Project Explorer Working With the Properties Window Working With the Work Area Working With a Code Module Running Procedures from the Editor Module 3: Procedures About Procedures Creating a Command Procedure Making Sense of IntelliSense Using the Edit Toolbar Commenting Statements Indenting Code Bookmarking In Procedures Module 4: Using Variables Understanding Variables Creating and Using Variables Implicit and Explicit Declarations The Scope of Variables Procedure Level Scoping Module Level Scoping Passing Variables by Reference Passing Variables by Value Data Types Declaring Data Types Using Arrays Using Intrinsic Constants Module 5: Functions About Functions Creating and Calling Functions The MsgBox Function Sending Messages to the User Using the InputBox Function Nesting Functions Using Functions in Function Procedures Module 6: Decision Structures The If...Then Statement Using If for Single Conditions Using If for Multiple Conditions The Select Case Statement Using the Select Case Statement Using Select for Sets of Values Using Select for Ranges of Values Module 7: Looping Structures For Loops Looping With Known or Specified Iterations Looping For Each Item Adding an Exit to a Loop The Do…Loop Statement Looping With Unknown Iterations Module 8: Working With Text Text And Document Components The Story Range The Selection Object Using The Selection Object The Range Object Using Range Objects Inserting Text Displaying Text In A Text Box The Find Object Performing A Find Operation Module 9: Document Management The Activate, Open And Close Methods Opening And Closing Documents The Add Method The Save And SaveAs Methods Creating And Saving Documents Properties That Return Information Functions That Return Information Getting Information Files, Folders And Drives Working With Files And Folders Displaying Files In A UserForm Removing Files And Folders The Application And Options Object Module 10: Creating Custom Forms About Custom Forms Creating A Custom Form Adding Text Boxes To A Form Adding Label Controls To A Form Changing Text Box Control Properties Adding A Combo Box Control Adding Option Buttons Adding Command Buttons Changing The Appearance Of Controls Running A Custom Form Module 11: Programming UserForms Handling Form Events Initialising A Form Closing A Form Creating Functions For A Form Coding Option Buttons Using The After Update Event Setting Bookmarks For Data Entry Using Bookmarks To Enter Data Setting The Tab Order Forcing Correct Entry Templates And AutoStart Macros Creating A Template With AutoMacros Module 12: Error Handling Error Types The On Error Statement Creating A Simple Error Handler Using The Resume Statement Using Decision Structures In Error Handlers Using The Err Object Error Handling In Event Procedures Defining Custom Errors Module 13: Builtin Dialogs The Dialogs Collection Dialog Box Arguments Using the Execute Method Using the Show Method The Display Method Using The Display Method Working With Dialog Tabs Using Dialogs With A UserForm

Course Ratings Averaged from 6 responses. Instructor's Knowledge Training Quality Training Objectives Training Overall Courseware Quality What do these ratings mean? Extraordinary Great Good Average Poor Name: Company: Phone: Email: Location: BrisbaneCanberraCrn-CairnsMelbournePerthSydney How can we assist you?: Bookmark & Share

Home | Search | Site Map | Legal | Privacy Policy | Terms of Use | Contact | Links & Resources | Career Opportunities

Copyright © 2009 New Horizons Learning Centres Holdings Pty Ltd. All rights reserved. ABN: 86 168 459 086

Developed by Globe Web Services