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...

Author: Cristian.Berescu Date: 10/21/2016

MSI - Generate SHA2 certificate with OpenSSL and sign a MSI installer project, use 'Application Control Policies'-'AppLocker' to block unsigned code

Some time ago I had to troubleshoot an issue with signed native C++ XLL add-ins for Excel, which...

Author: Cristian.Berescu Date: 10/24/2014

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...

Author: Cristian.Berescu 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...

Author: Cristian.Berescu 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...

Author: Cristian.Berescu 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,...

Author: Cristian.Berescu 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...

Author: Cristian.Berescu 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....

Author: Cristian.Berescu 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....

Author: Cristian.Berescu 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...

Author: Cristian.Berescu Date: 05/31/2012

VSTO & VBA - How to troubleshoot Excel memory and performance problems caused by inefficient code loops

When working with Excel, a developer sometimes has to search, read or write some cell values and...

Author: Cristian.Berescu Date: 04/27/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...

Author: Cristian.Berescu 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...

Author: Cristian.Berescu 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...

Author: Cristian.Berescu 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...

Author: Cristian.Berescu 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...

Author: Cristian.Berescu 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...

Author: Cristian.Berescu 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...

Author: Cristian.Berescu 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...

Author: Cristian.Berescu 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...

Author: Cristian.Berescu Date: 11/01/2010