Chapter Summary

• Access VBA exposes the Microsoft Office Object Model, which allows you to leverage much of the Microsoft Office internal functionality and utilities.

• Most Microsoft Office Objects are available to the suite of Microsoft Office applications. Some Microsoft Office Objects, however, are available only to specific suite applications.

• Sometimes Microsoft Office Object references are not set automatically. To set object references in VBA, use the References window.

• Setting an object reference sets a link to another application's objects for use in your code.

• The Assistant object exposes an animated Microsoft assistant character.

• With the Balloon object, you can create customized balloons to work with the assistant character.

• Command bars represent a number of user-interface entities such as toolbars, menu bars, and shortcut menus.

• The CommandBars collection contains all command bar objects in the current application.

• The CommandBarControl object represents controls found in menus and toolbars.

• Command bar controls can be buttons, boxes, and pop-up controls.

• The CommandBarButton object is a specialized command bar control that represents a button on a toolbar or menu that the user can click.

• Use the Customize dialog window to remove a custom command bar.

• The FileDialog object allows you to display and manage standard Open and Save file dialog windows.

0 0

Post a comment