The VBA language in Excel

Macros in Excel

Assign a macro

The VBE development environment

VBA Editor Settings

The VBA language: Modules and procedures


Decision structure and cycle


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


Form Customization

The user interface and command bar

Command bar controls

Event management

Event writing

Events on objects


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


API programming concepts

Code generation of an application

| /

Información relacionada a la formación

Soporte siempre a tu lado

Soporte de formación: Siempre a tu lado

Formación presencial y telepresencial

¿Necesitas otra modalidad formativa?


Bonificaciones para empresas