Microsoft Office programming with VBA («VBOFFP»)

1 Getting to know and repeat object models

• Object model of Excel
• Object model of Word
• Object model of Access

2 Early Binding vs. Late Binding

• Setting references
• Order of the references

3 Foundation: Access

• DAO vs. ADO
• Transfering data to Excel
• Transfering data to Word

4 Foundation: Excel

• Importing data from Access
• Exporting data to Word

5 Foundation: Word

• Mail merge (addresses from Access)
• Interrogate and insert data from Access
• Inserting charts from Excel

6 Ribbons and Backstage

• Modifying the ribbon and tabs
• Creating own ribbons and tabs
• Adjusting the backstage view

7 Tips and Tricks

Component of the following courses

• Bootcamp: Microsoft Visual Basic for Applications (VBA) («BCVBA1»)

This course is aimed at VBA developers who have very good knowledge of VBA programming (regardless of which Microsoft Office application they use) and would like to expand and deepen their knowledge in a holistic way.

No VBA basics are taught in this course. Very good VBA knowledge is required with at least 1-2 years of application experience and attendance at one of the following courses:

COURSE
VBA deepening for Excel («VBXLS»)
2 days
• Basel, Berne, Geneva, Lausanne, Zürich
CHF
1'300.–
Learn more
COURSE
VBA deepening for Word («VBWRD»)
2 days
• Basel, Berne, Zürich
CHF
1'300.–
Learn more
COURSE
VBA deepening for Microsoft Access («A07»)
2 days
• Basel, Berne, Zürich
CHF
1'490.–
Learn more