Resolving performance issues with loading Office add-ins (VSTO add-ins or Shared add-ins)

Many Office developers report performance issues with loading Office add-ins (VSTO add-ins or Shared add-ins) but most of the time delay is due to external factors. This blog post tries to list possible reasons for delay in add-in load.  1).Net Cold Start  – There could be some delay due to time taken to load the assemblies/dependencies…

2

Excel: How do you implement Application_Quit event in Excel/how do you intercept Excel application Quit

We know Word Object model provides an event handler called Application_Quit, which will be triggered when the application quits, but we don’t have any such events for Excel (even for PowerPoint and some other Office applications). In order to workaround this issue, first thing that will come in our mind is to use an Office…

0

Word 2003 SP3 throws intermittent error - There is insufficient memory. Save the document now

  Summary   An application automating Word 2003 SP3 intermittently throws below exception from Open method:   “System.Runtime.InteropServices.COMException (0x800A13E9): There is insufficient memory. Save the document now.”       Symptoms   Error Message: There is insufficient memory. Save the document now       Cause   This is a generic error message which can…

2

Troubleshooting COM Add-In load failures

This post helps troubleshoot Office COM Add-In load failures.  As there can be many factors contributing to the failure, it is necessary that we be methodical when we approach this issue to ensure we haven’t missed anything simple.   Before we begin, please note the terminology used in this post: COM Add-In is an Add-in…