There is a powerhouse of capabilities that are already sitting on most users desktops. Using Visual Studio Tools for Office, you can develop Add-Ins and Document Customizations that can add complex functionality to your users favorite applications. Allow them to interact with databases, services, external libraries, and many, many more. This course shows you how to get started developing an end-to-end solution using VSTO.
John Brown is a Software Craftsman continually looking for intuitive
designs, agile architectures, and streamlined processes. With degrees in
Computer Science from Johns Hopkins and Aerospace Engineering from Purdue,
John is always up for a challenge, especially in his areas of interest in
Artificial Intelligence and Machine Learning.
Visual Studio Tools for Office - Introduction Hi. This is John Brown, and this module is the first in a series of modules related to the Visual Studio Tools for Office. In this module, I'll introduce VSTO, and talk about how we can use VSTO to customize our experience with Microsoft Office, and how we can use it to provide customized solutions that leverage the capabilities of Microsoft Office. The goals of this module are to introduce which Microsoft Office products can be customized by VSTO. We'll talk about what VSTO provides to customize the user experience, and the graphical elements. We'll talk about how VSTO exposes the Interop libraries to allow document object manipulation, and how it provides specialized host controls that allow an improved interaction with the documents and the applications. We'll also discuss the differences between the two architectural models, which are document centric, and application centric.
Visual Studio Tools for Office - Ribbons This is John Brown, and this module is the second in a series of modules related to the Visual Studio Tools for Office. In this module, I'll talk about how we can use the features of VSTO to provide a customized user experience for our custom Microsoft Office solutions using the Microsoft Office Ribbon. Our goal in this module is to talk about ribbon controls, and how to develop them using both the graphical designer, and the custom XML that is provided by VSTO. We'll talk about how to make the ribbons change, based on need, with dynamic items, and we'll talk about how to work with the built-in Microsoft Office ribbons.
Visual Studio Tools for Office - Excel Hi. This is John Brown, and this is one of several modules in a series introducing Visual Studio Tools for Office. In this module, I'll talk about how we can use features of VSTO specific to customizing Microsoft Excel. The goal of this module is to introduce you to the document object model of Excel, and talk about the kinds of techniques we can employ. We'll then dive into specific VSTO host controls that expose the DOM in a more elegant fashion, such as named ranges, list objects for managing collections of items, charts for visualization of the data, and XML mapped ranges that allow a schema to be applied to the workbook so that imported XML data can be displayed in the same fashion for each run. What is VSTO? Visual Studio Tools for Office. As I discussed in the introductory module, VSTO provides. NET wrappers to the Primary Interop Assemblies, allowing us to use. NET to access, and control Microsoft Office. In this module, we'll use VSTO to work directly with the host items, and host controls specific to Microsoft Excel.
Visual Studio Tools for Office - Deploy and Install Hi. This is John Brown, and this is one of several modules in a series introducing Visual Studio Tools for Office. In this module, I'll talk about how we deploy, and install VSTO add-ins, and document customizations. This discussion is not specific to a particular Office application, and is applicable to any of the VSTO customizations. Our goals for this module are to walk through the requirements for installing any of the VSTO add-ins and document customizations. We'll talk about the required files, and runtimes that are to be deployed, the registry settings that need to be performed, and the document settings that are used to successfully deploy VSTO customizations. Once the requirements are specified, we'll talk about the two most common installation methods, Click Once, and the standard Windows Installers. We'll talk about how Click Once installations are setup for easy installations with minimal fuss, and automatic updates. When the installations become complicated, or require elevated security permissions, the Windows Installer can be used. We'll discuss the ins and outs of the Windows Installer, and how to best leverage that for your applications. And finally, we'll talk about the required security features, and the additional security options that are available. As you remember from the introductory modules, VSTO provides. NET wrappers around the Interop objects of the Office applications. These wrappers make it easy for the. NET developer to interact with Word, Excel, Outlook, and the others. But it also means that our. NET applications that run from inside of Word and Excel have to be registered with those applications, and follow the same security protocols.