Category Archives: Uncategorized

Excel-DNA version 0.34

Excel-DNA version 0.34 has been release and is now available on NuGet (as package ExcelDna.Addin 0.34.6), and as a standalone download from GitHub (https://github.com/Excel-DNA/ExcelDna/releases/tag/v0.34.6). Please post any issues you run into to the Google group (https://groups.google.com/forum/#!forum/exceldna) The easiest way to … Continue reading

Posted in 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 (https://exceldna.codeplex.com/releases/view/119190) and the NuGet package manager (https://www.nuget.org/packages/Excel-DNA/0.32.0-rc1) 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