How COM works & How to build a COM visible DLL in C#.Net, call it from VBA and select the proper ClassInterface (AutoDispatch, AutoDual) [part1/2]

  This article is split across two blog posts and this is part #1.. use this link (please be patient :), I am still working on part 2) to go to part #2. When a beginner programmer needs to create a COM visible DLL which will be called from VBA, PowerShell, VBScript or .NET applications, he can find lots of tutorials on how to…

2

OpenXML & VSTO & VBA – Finding a reliable mechanism for reading the correct value of CharactersWithSpaces ‘extended-properties’ in Word documents [part 2/2].

  This article is split across two blog posts and this is part #2 .. use this link to go to part #1. In part #1 of this article, I demonstrated how words are counted using OpenXML and I warned about the dangers of not getting it done correctly. Here is a short summary of the alternatives we have:    Can we obtain 100% reliable statistics? Method #1:       When Word…

0

How to customize the Word 2007 backstage menu using a Shared COM Add-in – Visual Studio 2008 SP1

          The new Microsoft Office Fluent user interface (UI) for Office 2007 and 2010 replaces the old 2003 interface with layered menus, toolbars, and task panes with a simpler system optimized for efficiency and discoverability. The new Fluent UI has improved context menus, Enhanced ScreenTips, a Mini toolbar, and keyboard shortcuts that help to…

0

Deploying a VSTO Word 2007 add-in to All Users (Visual Studio 2008 SP1)

_____________________________________________ !!!! [PERFORM THIS STEP FIRST] !!!!      To be able to deploy an Add-in to all users (without manually installing for each user account on a machine) you must download and install http://support.microsoft.com/kb/976811 (A 2007 Office system application does not load an add-in that is developed by using VSTO); To enable the hotfix package,…

3