Excel Programming

As well as developing products, Technicana also performs Excel consultancy, specialising in VBA and C# technologies. These articles describe some code and techniques that we have found useful.

ExcelDna

ExcelDna Function List
PIA Free, COM Registration Free Access to the Excel Object Model with .NET 4 and ExcelDNA (Part 1)

Add-ins and Utilities

Technicana Utilities
Excel Tools and Addins

Examples and Code

Automatically Resizing Excel Arrays
Bit Operations in VBA
Calculating Odds with Excel
Calculating the Next Occurrence Of A Day
Checking Cells for Formulas
Creating Add-ins for Excel 2003 and Excel 2007 (Part 1)
Creating Add-ins for Excel 2003 and Excel 2007 (Part 2)
Creating Add-ins for Excel 2003 and Excel 2007 (Part 3)
Default Methods in Vba Classes
Deleting Code Modules Programmatically
Excel Calculation Rules
Finding Precedents and Dependents
Find the Last Saved Date of a Document
Find Text, Starting from the Right
Gathering Bloomberg Data with Synchronous VBA Calls to the API
Generating Expired Futures Codes
Indenting Formulas
Named Ranges in Code
Passing Objects by Value in VBA
Programmatically Adding Code
Reference Box Modes
Signing an XLL
The Curious Case of Excel
VBA for Checking Dependencies on Other Sheets
Writing Registry Keys with Windows Management Instrumentation

Excel from .NET

Unprotect VBA from C# .NET
A Range Picking Form with VSTO
Improved Range Picker with VSTO
Export Word Documents to PDF with C#