Microsoft Office 97 Developer Course at EngineWorks

COURSE SEARCH

HOME > COURSE > MICROSOFT OFFICE 97 DEVELOPER

MEMBERS LOGIN

UNLIMITED ACCESS TO OVER 575 ONLINE TRAINING COURSES FOR ONE ANNUAL PAYMENT OF ONLY $149 USD
BUY NOW

HOME

COURSE LIBRARY

QUESTIONS & ANSWERS

There are many excellent online courses. This has been hugely beneficial in my day to day work.

- Louise Nolan

MORE INFO

Microsoft Office 97 Developer

Course Aims
This course has been specially designed for advanced user who wants to make use of the more powerful facilities of MS Office 97 made available by VBA. This course explores VBA language and readers will be encouraged to write programs to ensure that future editing, amending and updating can be carried out with the minimum of effort.

This course can be found in the following categories:

Course Library > Programming > Microsoft VBA
Course Library > Microsoft > Office 97
Course Library > Microsoft > Visual Basic

Table of Contents

Course Objectives

Course Objectives

Introduction

The Nature and Uses of the VBA Language

How Projects Relate to Documents

The Components you can Include in a Project

Where Code is Stored

Code in Microsoft Excel

Code in PowerPoint

Code in Microsoft Word

Types of Procedures

Record Code in Excel, Word and Powerpoint

Use the Visual Basic Editor to View, Modify and Run Code

Run Mode and Design Mode

Assign Code to a Menu or a Command Button on a Toolbar

The Automatic Help Facility

Review

Macros and Varibles

Create and Invoke Sub and Function Procedures

Entering Code

Insert Comments into the Code

Printing a Visual Basic Module

Using Variables

Declaring Variables

Scope of Variables

Lifetime of Variables

Determine the Appropriate Data Type to use in a Particular Scenario

Naming Conventions

Declare and Use Constants

Procedures

Objects, Properties and Methods

What are Objects?

Object Properties and Methods

Using Methods to Perform Actions

Performing Multiple Actions on an Object

Using Object Variables

Declaring an Object Variable

Setting an Object Variable

Determining whether an Object Variable is Set

Exploring Properties

The Object Library

The Hierarchy of Objects

Controlling an Object Model

Referencing an Object Library

Use the Object Browser to View an Object Model

Objects

VBA Programming Control Structures

If ... Then ... Else Statement

Select Case Statement

Do ... Loop Statement

Control Structures

Error Trapping and Debugging

Types of Errors

Error Handling

Setting an Error Trap

Debugging

Break Mode

The Immediate Window

The Locals Window

The Watch Window

The Call Stack

Error Handling

The Office Assistant

Assistant Object Model

Modifying the Assistant

Assistant Balloons

Displaying a Balloon

Office Assiatant

Menus and Toolbars - Command Bars

Overview

Manually Customising a Command Bar

CommandBars Object Model

Showing and Hiding a Command Bar

Adding Controls to a Command Bar

Creating a New Command Bar

Creating a Toolbar

Adding Advanced Controls

Creating a Command Bar

TRY BEFORE YOU BUY

BECOME A RESELLER

TERMS & PRIVACY

Tuesday 22nd May 2012