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

“HeaderFooter (unknown member) : Invalid request.” Error, while setting slide footer text in PowerPoint 2007 via .Net

Symptoms: While programming PowerPoint 2007 in .Net, when you try setting Footer text for slides, you may encounter the following error message, Error Message: HeaderFooter (unknown member) : Invalid request. Cause This is a known issue and has been reported to the product group Resolution To workaround this issue, first, we need to set the…

0

Excel: How do you implement Application_Quit event in Excel – In External automation scenario

You may have come across this blog which demonstrates how you can capture Excel’s quit event from an Add-In (in process). This post will be about capturing Excel’s quit event when you are externally automating Excel. Consider this situation – You have an application that automates Excel and presents Excel window to the user for…

0

MapPoint does not appear in the list of products while creating shared add-in in Visual Studio 2008

Issue Description: On a machine having Visual Studio 2008 and MapPoint 2009 installed, MapPoint does not appear in the list of products while developing a shared add-in using Visual Studio 2008, as shown below: This is a bug in MapPoint 2009. Workaround for this issue is to create necessary registry entries. Follow the steps below…

1

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

MapPoint control does not allow bringing other VB form to foreground

  Summary   When a MapPoint ActiveX control is placed on a VB6 windows form, other non modal forms that you open cannot be brought to foreground. Note : 1.       The issue has also been reported with Delphi forms. 2.       This issue DOES NOT occur with .Net windows forms.       Symptoms   Consider you…

1

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