The Curious Engineer

All blogs / C# / .NET

cristib

learn.microsoft.com/en-us/archive/blogs/cristib

Office Development Blog

C# / .NETSoftware / engineering practiceMicrosoft blogsMSDN archive

’10’15’20’25
Posts
18 from 1 Nov 2010 to 21 Oct 2016
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/cristib/feed.xml

2016 1

  1. C++ / VBA - How to send a COM object from VBA to a C++ DLL via PInvoke

2014 1

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

2013 1

  1. VSTO - Deploying a VSTO Word 2003 add-in to All Users using a CustomAction Installer override project for assigning CASPOL permissions

2012 8

  1. 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]
  2. 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.
  3. 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)
  4. OpenXML & VSTO & VBA - Finding a reliable mechanism for reading the correct value of CharactersWithSpaces 'extended-properties' in Word documents [part 2/2].
  5. OpenXML & VSTO & VBA - Finding a reliable mechanism for reading the correct value of CharactersWithSpaces 'extended-properties' in Word documents [part 1/2].
  6. VSTO & VBA - Improving Excel's performance when writing data into Sheets by using memory arrays instead of inefficient code loops
  7. 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)
  8. VBA - How to programmatically enable access to the VBA object model using macros

2011 4

  1. 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
  2. VB Script - Get the Full Domain User name for a process (Wscript + Active Dir. LDAP) and set the Office User Info
  3. How to troubleshoot the error message: "The following Microsoft Office solution cannot be installed due to a general installer error: <add-in name>.vsto. 0x80131604" when trying to install a VSTO 2010 Add-in.
  4. 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.]

2010 3

  1. VBA: How to get the account login user name and the account full name for a program (ex: Microsoft Word)
  2. How to customize the Word 2007 backstage menu using a Shared COM Add-in – Visual Studio 2008 SP1
  3. Deploying a VSTO Word 2007 add-in to All Users (Visual Studio 2008 SP1)