Office 2016 Integrated Solution Development

Office 2016 Integrated Solution Development

This course will teach students how to develop integrated Office solutions using VBA.  Solutions will use macros and macro-enabled templates to pass data back and forth among different software applications within Microsoft Office, collecting data and soliciting input from other files as well as from users.  Students will not need to know how to code in VBA; the curriculum will teach them how to customize the code written during macro creation. 

Solutions can be adapted and applied to real world situations, including user-driven surveys in Word, data-driven score sheet production in Excel, generating letters in Word using data from Excel (and saving them as Word or pdf files), and using Excel data selections to drive dynamic input of text and images into existing Word documents.

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

Url: View Details

What you will 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.

Rating: 4.3

Level: Expert Level

Duration: 7 hours

Instructor: Russell Mangum