Macros in Excel

Assign a macro

The VBE development environment

VBA Editor Settings

The VBA language: Modules and procedures

Variables

Decision structure and cycle

Operators

Code writing rules

The Excel Object Model

Principles of use of objects and collections

Instructions, the object examiner

Objects: Application, Workbook, WorkSheet, Range.

Integrated Dialog Boxes
Predefined dialog boxes

Forms

Form Customization

The user interface and command bar

Command bar controls

Event management

Event writing

Events on objects

Debugging

Communicating with Office applications

Communication with Word from Excel

Communicating with Access from Excel

Communication with Outlook from Excel

Linked or embedded objects

Link Methods and Properties

The QueryTable target

Publishing web pages

WebOptions and DefaultWebOptions objects

XML file management

Hyperlink

API programming concepts

Code generation of an application