VBA Programming with Office 2019 (O19VBA)

 

Course Overview

With the book "VBA Programming - Integrated Solutions with Office 2019" you will learn the most important programming techniques and the object models up to the development of your own integrated solutions in all Office applications. This compact VBA Office training book is ideal for use in training courses and for self-study. Benefit from numerous tips, the commented code examples and the exercises at the end of the chapters.

  • The VBA development environment and language elements
  • Object-oriented programming with VBA
  • Shared VBA elements
  • Programming of Office applications
  • Communication between Office applications
  • Use custom dialogs
  • Database access in Office applications
  • Integrated solutions with Office 2019 applications

Tailored to the learning topics in "VBA Programming - Integrated Solutions with Office 2019", BuchPlus gives you a comprehensive digital media package with sample, practice, and results files, quick reviews, knowledge tests, supplemental learning content, and a glossary.

This text was automatically translated. Please click here to read the original German version.

Course Content

  • 1 Before you start
  • 2 Office programmieren
  • 3 The VBA development environment
  • 4 The language elements of VBA
  • 5 Object-oriented programming with VBA
  • 6 Shared VBA elements
  • 7 Programming the Office applications
  • 8 Communication between office applications
  • 9 Using Custom Dialogs
  • 10 Database access in Office applications
  • 11 Integrated solutions with Word
  • 12I ntegrated solutions with Excel
  • 13 Integrated solutions with Access
  • 14 Integrated solutions with PowerPoint
  • 15 Integrated solutions with Outlook

Prices & Delivery methods

Online Training

Duration
2 days

Price
  • 1,190.— €

Courseware language: German

Classroom Training

Duration
2 days

Price
  • Germany: 1,190.— €
  • Switzerland: CHF 1,520.—

Courseware language: German

Schedule

Instructor-led Online Training:   Course conducted online in a virtual classroom.
FLEX Classroom Training (hybrid course):   Course participation either on-site in the classroom or online from the workplace or from home.

German

Time zone: Central European Summer Time (CEST)   ±1 hour

Online Training
Classroom option: Berlin
Time zone: Central European Summer Time (CEST) Course language: German
Online Training Time zone: Central European Summer Time (CEST) Course language: German
Online Training Time zone: Central European Summer Time (CEST) Course language: German
Online Training
Classroom option: Frankfurt
Time zone: Central European Summer Time (CEST) Course language: German
Online Training Time zone: Central European Time (CET) Course language: German
FLEX Classroom Training (hybrid course):   Course participation either on-site in the classroom or online from the workplace or from home.

Germany

Berlin Course language: German
Frankfurt Course language: German

If you can't find a suitable date, don't forget to check our world-wide FLEX training schedule.