cristib
Office Development Blog
C++ / VBA - How to send a COM object from VBA to a C++ DLL via PInvoke
Today I would like to present a quite uncommon scenario, which involves requesting a COM object from...
Date: 10/21/2016
VBA - Access 2013 - Programmatically assigning a Form's (DAO RecordSet) Record Source to the result of Stored Procedure (ADO RecordSet) executed on a remote SQL Server triggers “Run time error 31 – Data provider could not be initialized” error message.
Suppose we have this scenario where a local Access database uses Forms bound to SQL serverdata...
Date: 08/28/2014
VSTO - Deploying a VSTO Word 2003 add-in to All Users using a CustomAction Installer override project for assigning CASPOL permissions
Deploying a VSTO 2003 add-in is a little more complicated than the 2007 and 2010 versions. This is...
Date: 02/28/2013
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...
Date: 10/31/2012
VSTO - How to build a setup project which targets x64 bit OS, and add custom Registry Launch Condition that checks if a key is found in the native 64bit registry hive.
A developer that needs to learn all about building and deploying a VSTO 2010 installer project,...
Date: 09/28/2012
VSTO - .Net code throws 'System.AccessViolationException' error when automating the 'Find' object in Word (KB 292744 BUG: Automation client receives an error message or crashes when the client calls the Find object in Word)
Sometimes users are running versions of Office which are not fully up-to-date. This might be due to...
Date: 08/31/2012
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....
Date: 07/30/2012
OpenXML & VSTO & VBA - Finding a reliable mechanism for reading the correct value of CharactersWithSpaces 'extended-properties' in Word documents [part 1/2].
This article is split across two blog posts and this is part #1 .. use this link to go to part #2....
Date: 06/30/2012
VSTO & VBA - Improving Excel's performance when writing data into Sheets by using memory arrays instead of inefficient code loops
In my previous article (VSTO & VBA - How to troubleshoot Excel memory and performance problems...
Date: 05/31/2012
VBA - How to Find and Edit the Office 2003 legacy CommandBars and menus in Office 2010 (add, remove, edit controls in 'Menu Commands' group from Add-Ins tab)
Today I am going to show you how to work with legacy CommandBar controls in Office 2010. Let's...
Date: 03/30/2012
VBA - How to programmatically enable access to the VBA object model using macros
Under certain circumstances a programmer may need to access the VB object model for an Office...
Date: 02/29/2012
Visual Studio 2010 (Windows Forms Application): Working with the Visio 2010 control (Microsoft Office Visio 14.0 Drawing Control - 'AxInterop.Microsoft.Office.Interop.VisOcx.dll), and how to enable the hidden ‘Shapes’ pane
. . Where did the 'Shapes' pane disappear in the 2010 version of the Microsoft Office Visio 14.0...
Date: 12/28/2011
VB Script - Get the Full Domain User name for a process (Wscript + Active Dir. LDAP) and set the Office User Info
This blog post is going to follow-up on my previous article...
Date: 11/15/2011
How to troubleshoot the error message: "The following Microsoft Office solution cannot be installed due to a general installer error: .vsto. 0x80131604" when trying to install a VSTO 2010 Add-in.
Suppose you develop a simple VSTO Add-in using Visual Studio 2010 and you target the .Net Framework...
Date: 06/06/2011
Deploying a Shared COM add-in for Office 2003 (Visual Studio 2008 SP1) [and how to work around a known issue which causes the add-in to fail to load if KB908002 is not installed.]
Office add-ins can target an application (or many applications if they are Shared COM Add-ins) or...
Date: 04/04/2011
VBA: How to get the account login user name and the account full name for a program (ex: Microsoft Word)
If you need to retrieve the [ user name ] and [ full name ] fields of the account under which a...
Date: 12/16/2010
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...
Date: 11/26/2010
Deploying a VSTO Word 2007 add-in to All Users (Visual Studio 2008 SP1)
_____________________________________________ !!!! [PERFORM THIS STEP FIRST] !!!! To be able to...
Date: 11/01/2010