Office 2016 Integrated Solution Development

Learn how to develop solutions in Office 2016 using VBA - without learning VBA! Let the programs write the code.

Created by: Russell Mangum
Experienced developer and tech instructor

What Will I Learn?

• Develop integrated solutions using Excel and Word.
• Tweak the VBA code written by the macro recorder, adding variables and arguments.
• Create compound macros, which themselves call other macros, often macros in other files or programs.
• Develop VBA userforms to solicit and validate data from users.
• Build solutions that pass data from Excel to macro-enabled templates and trigger file-handling macros in other programs.

Requirements

• You should have a basic familiarity with creating and using macros in Excel and Word.
• You need to have a version of Office installed on your computer. The online version won't suffice.

Target audience

• Any Office user who wants to learn to develop solutions without having to learn VBA first.