excel-addins - w3toppers.com

How to perform .Onkey Event in an Excel Add-In created with Visual Studio 2010?

“I would like to run some code when users presses a combination of keys.” Its tricky and to do it without any external dependencies resort to Keyboard hooking to achieve it with a VSTO Excel Add-in: Imports System Imports System.Runtime.CompilerServices Imports System.Runtime.InteropServices Imports System.Windows.Forms Friend Class KeyboardHooking ‘ Methods <DllImport(“user32.dll”, CharSet:=CharSet.Auto, SetLastError:=True)> _ Private Shared … Read more

How do I create a real-time Excel automation add-in in C# using RtdServer?

(As an alternative to the approach described below you should consider using Excel-DNA. Excel-DNA allows you to build a registration-free RTD server. COM registration requires administrative privileges which may lead to installation headaches. That being said, the code below works fine.) To create a real-time Excel automation add-in in C# using RtdServer: 1) Create a … Read more

Loading addins when Excel is instantiated programmatically

I looked into this problem again, and the Application.Addins collection seems to have all the addins listed in the Tools->Addins menu, with a boolean value stating whether or not an addin is installed. So what seems to work for me now is to loop through all addins and if .Installed = true then I set … Read more

I don’t want my Excel Add-In to return an array (instead I need a UDF to change other cells)

It is actually possible albeit complex. I am reposting this piece of magic from Kevin Jones aka Zorvek as it sits behind the EE Paywall (link attached if anyone has access) While Excel strictly forbids a UDF from changing any cell, worksheet, or workbook properties, there is a way to effect such changes when a … Read more