Office 2016 Integrated Solution Development

Course details

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.