Category Archives: Uncategorized

Excel UDF IntelliSense for Excel-DNA and VBA

I’m happy to announce the first official release of the IntelliSense extension! Excel-DNA IntelliSense provides on-sheet help for UDF functions as they are entered into a cell formula, similar to the help available for built-in Excel functions. For Excel-DNA add-ins … Continue reading

Posted in Uncategorized

Add-in spotlight: ACQ for interpolation

This is the first in an occasional series of posts about interesting Excel-DNA based add-ins. Alex Chirokov’s ACQ add-in provides a library of interpolation routines for Excel. The add-in includes 1D and 2D interpolators, scatter plot smoothing and a Mersenne Twister random number … Continue reading

Posted in Uncategorized

Excel-DNA 0.33 Release Candidate and License Change

Version 0.33 Release Candidate Excel-DNA 0.33 contains a number of bug fixes and improvements, including a diagnostic logging approach based on the .NET Trace classes. More details can be found in the current ChangeLog. This version will also be the foundation … Continue reading

Posted in Uncategorized

Excel-DNA 0.32 – Breaking changes to integer and boolean parameter handling

Excel-DNA version 0.32 introduces some changes in the parameter conversions applied to integer and boolean parameters. These changes improve compatibility with VBA, and make it easier to provide a consistent implementation when the conversion needs to be explicitly implemented, as for … Continue reading

Posted in Uncategorized | Tagged ,

Tutorial: COM server support for VBA integration

Functions and macros created in an Excel-DNA add-in can be called directly from Excel VBA by using Application.Run(…). However, .NET also supports creating rich object models that are exported as COM libraries, which can be Tools->Referenced in VBA. Excel-DNA has … Continue reading

Posted in Uncategorized | Tagged , , , , , , ,

Excel-DNA 0.32 Release Candidate

I have posted to CodePlex ( and the NuGet package manager ( a release candidate of the next Excel-DNA version.I hope to make a final release in the next few weeks, once I’ve had confirmation that this version works well … Continue reading

Posted in Uncategorized

Getting started with F# and Excel-DNA in finance

Bram Jochems has written a friendly  ‘Getting Started’ post, discussing how to use F# with Excel-DNA in a finance context. His add-in with various F# / Excel-DNA helper utilities, and a bunch of quantitative finance-related UDFs, including option pricing function and … Continue reading

Posted in Uncategorized | Tagged ,