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

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

MapPoint and Data Execution Prevention(DEP)

A developer using MapPoint 2006 and Visual Studio 2008 on Vista was developing a windows based application, with the MapPoint control placed on the windows form. He was using the following code: Private _objMap As MapPoint.MapPrivate Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load      _objMap = AxMappointControl1.NewMap(MapPoint.GeoMapRegion.geoMapEurope)End Sub Every time he ran…

1

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…