Summary

The core Microsoft Office applications contain a great depth of functionality that you can leverage to develop Office-based solutions. In this lab, you learned a basic and an advanced way to connect Excel to an external data source to provide an interactive reporting experience. Additonally, you were introduced to the Visual Basic Editor – a built-in development environment for writing Visual Basic for Applications (VBA) code to automate Microsoft and develop custom user interfaces for your applications.