Ask Learn
Preview
Ask Learn is an AI assistant that can answer questions, clarify concepts, and define terms using trusted Microsoft documentation.
Please sign in to use Ask Learn.
Sign inNote
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Office Development Blog
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
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
The new Microsoft Office Fluent user interface (UI) for Office 2007 and 2010 replaces the old 2003...
Date: 11/26/2010
_____________________________________________ !!!! [PERFORM THIS STEP FIRST] !!!! To be able to...
Date: 11/01/2010