Browse by Tags

All Tags » Add-In
  • Events in VSTA Part IV: Unloading Add-ins that do not Unhook from Events

    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 event is raised. To prevent ...
    Posted to Melody's VSTA Blog (Weblog) by Melody on May 16, 2008
  • VSTA and LINQ to XML with Excel

    VSTA 2 can be used to extend a host application to use LINQ in a variety of ways.  One example of this is to use LINQ to XML to use an XML file as input.  LINQ to XML is doubly convenient because Office products, such as Excel 2007, work well with XML files. Using LINQ to XML to input data that was created or manipulated in an ...
    Posted to Melody's VSTA Blog (Weblog) by Melody on April 15, 2008
  • Error "xxx.rem has been disconnected or does not exist at the server"

    When an add-in does not communicate with the host for 5 minutes or longer, then attempts to communicate again the error ''xxx.rem has been disconnected or does not exist at the server'' occurs.  This happens both during debugging and at run time and is due to unwanted garbage collection.   This is a bug outside of VSTA and will be ...
    Posted to Melody's VSTA Blog (Weblog) by Melody on April 2, 2008
  • Re: ApplicationEntryPoint

    Ernst,  Do you have a VSTA v 1 ShapeAppCSharpProxy in registered in the GAC?  If so delete it- you only want on eShapeAppCSharpProxy assembly in the GAC (for side by side scenarios it is recommended that you use different names for the proxy assemblies).Please let me know if you have any other questions.Thanks,   -Melody
    Posted to Install/Setup Issues (Forum) by Melody on March 4, 2008
  • Post Build Events in VSTA

    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 about them. File:  ...
    Posted to Melody's VSTA Blog (Weblog) by Melody on February 19, 2008
  • Project Templates: ProjectGen and "Unregistering" templates

    To remove or ''unregister'' project templates: The easiest way to remove or ''unregister'' project templates which are registered with a host is to use the vsta and devenv setup commands.  These commands get the VSTA project templates location and the Visual Studio project templates locations specified in the VSTAHostConfig ...
    Posted to Melody's VSTA Blog (Weblog) by Melody on February 7, 2008
  • Re: CAB (Composite UI Application Block)

    Ric,    By default ProjectGen creates add-ins which use a reference to the proxy.dll in the GAC.  As long as you are reinstalling the latest copy of the proxy in the GAC and don't change your add-ins to use a local copy, your add-ins will see the changes.  If you change something in the proxy like a scope, parameter type, or ...
    Posted to VSTA Tech Discussions (Forum) by Melody on January 17, 2008
  • Using VSTA v 2 with Visual Studio 2005

    Microsoft recommends using Visual Studio 2008 for integrating VSTA v 2. However, if you choose to use Visual Studio 2005 the following will need to be addressed. 1)  The framework VSTA v 2 uses the 3.5 framework. It is very important that references, like System.AddIn, point to the 3.5 versions and not the 2.0 versions.  The .Net 3.5 ...
    Posted to Melody's VSTA Blog (Weblog) by Melody on January 15, 2008
  • Moving and Organizing DLL’s to Make VSTA Integration Easier. Part I- Projects

    Overview: Finding DLL’s programmatically can be challenging if they are not well organized.  For VSTA integration several DLL’s may need to be found including add-in’s to load.  In the ShapeApp samples included with the SDK, the add-in samples copy their DLL’s into the folders %MyDocuments%\%HostID%\AppAddins and ...
    Posted to Melody's VSTA Blog (Weblog) by Melody on July 2, 2007