Issue: Change in behavior from Office 2007 RTM to SP2 when Sheet.Unprotect is called

Let’s say you have a password protected Excel workbook, and you are calling following function through VBA in it: Sheet.Unprotect Password:=”” If you run this macro in Office 2007 RTM or SP1 version, it will result in a VBA Error; provided the actual password is not an empty string. However, in SP2 it will result…


Issue: Formatting individual characters of Data Labels of Charts programmatically in Excel 2007 SP2

If you are working with Charts programmatically in Excel 2007 Service Pack 2, and are trying to set the formatting of individual characters of Data Labels of charts programmatically, you will notice that the formatting gets applied to the whole of Data Label instead of the specific character/range. Here is a snippet which one would…


WORD 2003/EXCEL 2003: VSTO Customization added using ServerDocument.AddCustomization method does not add customization if your document contained an embedded VSTO customized Document/WorkBook

PROBLEM DESCRIPTION Consider this scenario. You are adding VSTO customizations dynamically to Word 2003/Excel 2003 documents using ServerDocument.AddCustomization method.  The ServerDocument.AddCustomization method succeeds. But when you try to open this customized document, the customization does not load. If you have the “VSTO_SUPPRESSDISPLAYALERTS” environment variable set to “0” you will get the following error:  “The customization…

2

Presentation Close event is incorrectly fired while issuing Presentation Print Command

Summary When the print command of a PowerPoint Presentation is issued, the presentation.close event is fired in addition to the Print event・  However, the expected behavior is that the presentation.close event should not get fired when the print command is issued.   Cause This is a known issue with PowerPoint 2003/ 2007.   Resolution Either…


How to Sign the SignatureLine using Office Open XML

Introduction We can use PackageDigitalSignatureManager class available in System.IO.Packaging namespace to sign any part of an Open XML document. However, when we try to sign a document that has a signature line using this class, we will notice that though the document appears as signed, the signature line still appears as “needs to be signed”….

3

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

Visual Basic 6 Controls stop working after Security Advisory 960715

Summary of the issue: After installing security advisory 960715 and opening a workbook with one of Visual Basic 6 ActiveX controls embedded in the workbook you receive an error: “Object library invalid or contains references to object definitions that could not be found” or “Element not found.” See Microsoft security bulletin MS08-070 article 932349 for…


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