________________________________________________________________
Do you want to take this course remotely or in person?
Contact us by email: info@nanforiberica.com , phone: +34 91 031 66 78, WhatsApp: +34 685 60 05 91 , or contact Our Offices
________________________________________________________________
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
