Home
Introduction

Getting Started with Visual Basic
Using Online Help
Other Resources
How This Book Is Organized
Document Conventions

Chapter 1:   Programming Basics

Writing, Editing, and Running Code in the Visual Basic Editor
Variables, Constants, and Data Types

Chapter 2:   Understanding Object Models

Overview of Object Models
Automating a Task by Using Objects
Programming Another Application's Objects

Chapter 3:   Microsoft Access Objects

Objects Available in Microsoft Access
The Microsoft Access Objects
The Application Object
The Form Object and the Forms Collection
The Report Object and the Reports Collection
The Control Object and the Controls Collection
The Module Object and the Modules Collection
The Reference Object and the References Collection
The DoCmd Object
The Screen Object

Chapter 4:   Microsoft Excel Objects

Working with the Application Object
Working with the Workbook Object
Working with the Range Object
Working with Events

Chapter 5:   Microsoft Outlook Objects

The Outlook Object Model
Working with Outlook Folders
Working with Outlook Items and Events
Using Automation and VBScript

Chapter 6:   Microsoft Powerpoint Objects

Working with the Application Object
Working with the Presentation Object
Working with the Slide, SlideRange, and Slides Objects
Working with the Selection Object
Working with the View and SlideShowView Objects
Controlling How Objects Behave During a Slide Show

Chapter 7:   Microsoft Word Objects

Working with the Application Object
Working with the Document Object
Working with the Range Object
Working with the Selection Object
Working with the Find and Replacement Objects
Working with Table, Column, Row, and Cell Objects
Working with Other Common Objects
Modifying Word Commands
Determining Whether an Object Is Valid
Working with Events
Using Auto Macros
Using Automation

Chapter 8:   Menus And Toolbars

Tools for Modifying the User Interface
Scope of Changes to the User Interface
Choosing the Best User-Interface Enhancement
The Menu System
Design-Time Modifications to the Menu System
Run-Time Modifications to the Menu System
Toolbars
Design-Time Modifications to Toolbars
Run-Time Modifications to Toolbars
Menu Item and Toolbar Control IDs

Chapter 9:   Microsoft Office Assistant

Using the Microsoft Office Assistant
Using the Microsoft Office Assistant Balloon

Chapter 10:   Shapes And The Drawing Layer

Understanding the Shape, ShapeRange, and Shapes Objects
Drawing a Shape on a Document, Worksheet, or Slide
Editing a Shape
Working with OLE Objects on a Document, Worksheet, or Slide
Working with More Than One Shape

Chapter 11:   Data Access Objects

Working with DAO Objects
Using DAO with Microsoft Jet
Accessing ODBC Data
Using DAO with ODBCDirect
Using ODBCDirect

Chapter 12:   Activex Controls And Dialog Boxes

Designing Custom Dialog Boxes
Using Custom Dialog Boxes
Working with Controls on a Document, Sheet, or Slide
Working with Controls Programmatically

Chapter 13:   Optimizing For Size And Speed

General Optimization Strategies
Strategies for Optimizing Microsoft Excel
Strategies for Optimizing Microsoft Word

Chapter 14:   Debugging And Error Handling

How to Handle Errors
Designing an Error Handler
The Error-Handling Hierarchy
Testing Error Handling by Generating Errors
Inline Error Handling
Centralized Error Handling
Turning Off Error Handling
Handling Errors in Referenced Objects
Approaches to Debugging
Avoiding Bugs
Design Time, Run Time, and Break Mode
Using the Debugging Windows
Using Break Mode
Running Selected Portions of Your Application
Monitoring the Call Stack
Testing Data and Procedures with the Immediate Window
Special Debugging Considerations
Tips for Debugging

Chapter 15:   Developing Applications For The Internet And World Wide Web

Developing Internet Applications
Internet Terms and Concepts
Working with Hyperlinks
Saving Documents and Objects as HTML
Opening and Importing HTML Data
Using the WebBrowser Control
Using the Internet Transfer Control
Using the WinSock Control
Setting Up a Personal Web Server

Appendix A:   Switching From The Microsoft Excel 4.0 Macro Language

Information for Users of Microsoft Excel 4.0 Macros
Visual Basic Equivalents for Common Macro Functions
Creating Custom Commands and Dialog Boxes Using Visual Basic

Appendix B:   Switching From WordBasic

Logistical Programming Changes in Microsoft Word 97
Conceptual Differences Between WordBasic and Visual Basic
Determining Which Properties or Methods to Use
Using WordBasic Statements and Functions
Selection Object vs. Range Object
Miscellaneous Changes
Example Macros