With the introduction of LINQ to XML and the OpenXml formatting of Office 2007 documents it is incredibly easy to use VSTA to import and export data from a host application to an Office document and vice versa. One benefit of using OpenXml (or for Excel straight xml as well) is that this can be performed...
As mentioned in Part III, any events an add-in hooks into should be unhooked in the add-in, presumably in the Shutdown method. Unfortunately, if the add-in does not unhook from an event this can cause problems- namely that the host application will continue to attempt to reach the add-in code when the...
Post build events are very important in VSTA (versions 1 and 2). They are used to install files in the GAC, organize DLL's for add-in discovery, and in VSTA v 2, to rebuild the pipeline. Here are the files used in post build events by the ShapeApp samples, the commands which run them, and some information...