“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

Word 2007: Customizing Document inspector leaves instance of Word open in the memory.

  Symptoms: If you have customized Document inspector for Word 2007 using IDocumentInspector interface, after running the Document Inspector on the document and then exiting out of Word, will leave an instance of the application in memory Cause When you invoke the Document inspector, you pass in the Document object to the Inspect and the…

0

Excel 2007: Ribbon tabs (TabAddIns) disappear from doc level customizations if user opens and closes a doc running in the same instance of Excel

Symptoms: Consider a scenario where you have developed a Document level customization for Excel 2007 using Visual Studio Tools for Office 3.0 and you have customized the default tab (TabAddIns) to add any Office Ribbon control. You will notice that the “AddIns” tab is no longer available, if you open or create a new Excel…

0

How to loop through the app-domains in the current process

Consider a scenario where we have a VSTO add-in and an automation add-in for Excel and we want to share some objects from the VSTO addin to the Automation add-in. Because the VSTO add-in is loaded in its own separate appdomain and the automation add-in is loaded in the different(default) appdomain, sharing objects is not…

0

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