I have posted a release candidate of Excel-DNA version 0.29 to the CodePlex site. The download is available at http://exceldna.codeplex.com/releases/view/66405. I will wait a week or two for some confirmation that this version works correctly before setting this release to "recommended" status and updating the NuGet package. Any results from your testing with this version would be very helpful.
Excel-DNA version 0.29 adds support for a number of specialized Excel features. The 64-bit version of Excel 2010 is fully supported, registration-free Custom Task Panes can be created under Excel 2007 and later, direct COM server integration can improve integration with legacy VBA code, and macros with parameters are registered. In addition, there are some features to improve the development and debugging workflow, and a few minor bugfixes. The complete change list is included below.
More information about the new features will be posted on the Excel-DNA website in the coming weeks. Any comments or questions are welcome on the Google group - http://groups.google.com/group/exceldna - or by contacting me directly.
As always, I greatly appreciate any feedback on this version, and on Excel-DNA in general.
Complete change list
- BREAKING CHANGE! Changed
ExcelReferencetype to an
IntPtrfor 64-bit compatibility.
- Changed initialization - only create sandboxed
AppDomainunder .NET 4 (or if explicitly requested with
DnaLibrarytag in .dna file).
- Fixed memory leak when getting
- Fixed Ribbon
RunTagMacrowhen no Workbook open.
- Added support for the 64-bit version of Excel 2010 with the .Net 4 runtime.
- Added Cluster-safe function support for Excel 2010 HPC Cluster Connector - mark functions as
CustomTaskPanesupport and sample.
- Added COM server support for RTD servers and other
ExternalLibrariesand Projects as
ComServer="true"in the .dna file. Supports
Regsvr32registration or by calling
ComServer.DllRegisterServer. Allows direct RTD and VBA object instantiation. Includes
TypeLibregistration and packing support.
- Added support for macros with parameters.
- Added C# 4 dynamic type sample.
- Added Path attribute to
SourceItemtag to allow external source.
ExternalLibrarytag to prevent locking of .dll.
/Ooutput path option to
- Added "before" option to CommandBars xml.
Int64support for parameters and return values.