|
ms801-ver6.7-sg
Programming in VBA Microsoft Word 2003 (3 day)
DescriptionThe skills and knowledge covered in this publication are sufficient to create VBA applications in Microsoft Word 2002 or 2003.
Audience
This publication is primarily designed for people who need to know how to program applications for Microsoft Word 2002/2003 using Visual Basic for Applications.
Suggested Prerequisites• This publication assumes a sound knowledge of Microsoft Word.
• A general understanding of personal computers and the Windows operating system is also beneficial.
MethodologyThis series of publications has been written with one topic per page. Topic sheets either contain relevant reference information, or detailed step-by-step instructions designed on a real-world case study scenario.
Instructor Resources
Many of the topics require you to open an existing file with data in it. These files can be downloaded free of charge (after your purchase of the courseware) from our web site at www.sideris.com and navigating to the Downloads area.
ObjectivesAt the completion of this courseware participants will be able to:
• create macros in Word
• understand the Word object model and VBA concepts
• work with the 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 outcome of your program
• use looping structures to repeat sections of code
• work with text using a range of objects
• customise the way files and folders are managed
• create a custom form complete with controls and event procedures
• create code to drive a UserForm
• write a variety of error handling routines
• use Word's built-in dialog boxes.
Course OutlineMacros • Understanding Word Macros • Setting A Macro Security Level • Recording A Simple Macro • Running A Macro • Assigning A Macro To A Toolbar • Modifying A Macro Tool • Assigning A Macro To A Menu • Assigning A Macro To A ShortCut Menu • Creating A Custom Pull-Down Menu • The Many Ways Of Running A Macro • Editing A Macro • Deleting A Macro • Removing References To Macros • Creating A Macrobutton Field • Tips For Developing Macros
Understanding VBA • VBA Terminology • Accessing The Word Object Model • Using The Immediate Window • Working With Object Collections • Setting Property Values • Using The Object Browser • Programming With The Object Browser
Using 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
Procedures • Creating A Command Procedure • Making Sense of IntelliSense • Using The Edit Toolbar • Commenting Statements • Indenting Code • Bookmarking In Procedures
Using Variables • Creating & 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
Functions • Functions Theory • Creating & Calling Functions • The MsgBox Function • Sending Messages To The User • Input Techniques • Using The InputBox Function • Nesting Functions • Using Functions In Function Procedures
Decision Structures • The If 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
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
Working With Text • Text & Document Components • The Story Range • The Selection Object • Using The Selection Object • The Range Object • Using Range Objects • Project - Inserting Text • Code - Inserting Text • Project - Displaying Text In A Text Box • Code - Displaying Text In A Text Box • The Find Object • Project - Performing A Find Operation • Code - Performing a Find Operation
Document Management • The Activate Open & Close Methods • Opening & Closing Documents • The Add Method • The Save & SaveAs Methods • Project - Creating & Saving Documents • Code - Creating & Saving Documents • Properties That Return Information • Functions That Return Information • Project - Getting Information • Code - Getting Information • Files Folders & Drives • Working With Files & Folders • Project - Displaying Files In A UserForm • Code - Displaying Files In A UserForm • Removing Files & Folders • The Application & Options Object
Creating 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
Programming UserForms • Initialising A Form • Closing A Form • Creating Functions For A Form • Coding Option Buttons • Project - Using The After Update Event • Code - Using The After Update Event • Setting Bookmarks For Data Entry • Project - Using Bookmarks To Enter Data • Code - Using Bookmarks To Enter Data • Setting The Tab Order • Forcing Correct Entry • Templates And AutoStart Macros • Creating A Template With AutoMacros
Error Handling • Error Types • The On Error Statement • Creating A Simple Error Handler • Using The Resume Statement • Using Decision Structures In Error Handlers • Project - Using The Err Object • Code - Using The Err Object • Project - Error Handling In Event Procedures • Code - Error Handling In Event Procedures • Defining Custom Errors
Built-in Dialogs • The Dialogs Collection • Dialog Box Arguments • Using The Execute Method • Using The Show Method • The Display Method • Using The Display Method • Project - Working With Dialog Tabs • Code - Working With Dialog Tabs • Project - Using Dialogs With A UserForm • Code - Using Dialogs With A UserForm
|
|
|
|
