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 RTD Caching–Memory usage

  Microsoft Office Excel provides a worksheet function, RealTimeData (RTD). This function enables you to call a Component Object Model (COM) Automation server  provides you with a way to view and update data in real time. This real-time data (RTD) feature is great for working with constantly-changing data such as stock quotes, currency exchange rates,…

0

Creating charts in Word and PowerPoint using newly introduced Object Model in Office 2007 Service Pack 2

Office 2007 SP2 has added a major inclusion to the Object Models of Word and PowerPoint, i.e., Object Model for Charts. This new object model (OM) provides office application programmers flexibility to manipulate charts programmatically in Word and PowerPoint. The new OM in Word and PowerPoint is similar to the one that existed for Excel…

27

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

Access automation does not work from 64 bit .Net application

  Summary   A .Net 64 bit application automating Microsoft Access throws an error while opening Access database. Same code works fine when run as 32 bit .Net application. Below is the sample code to reproduce this issue:   Microsoft.Office.Interop.Access.Application accessApplication; accessApplication = new Microsoft.Office.Interop.Access.Application(); accessApplication.OpenCurrentDatabaseOld(“<Path to .accdb file>”, true);   Below is the exception…

3