Course
Microsoft Office programming with VBA («VBOFFP»)
In this two-day seminar you will learn how to use Microsoft Office applications across VBA and how to improve your processes.
Duration
2 days
Price
1'400.–
Course documents
Digital courseware
Course facts
- Deepening VBA skills in MS Office applications
- Understanding the object models of Excel, Word and Access
- Expanding and customising the ribbon and backstage view
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 Tipps & Tricks
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: