The Excel DNA thread

[Cuchulainn]

We have had some questions



1. Starting Excel in different ways.

2. Versions of Excel.



Here is the discussion from the EXCEL_DNA owner. I quote:



"The one question is about automating Excel from an outside program. In this case managing the COM references so that Excel will quite properly is quite tricky. One option is to use the NetOffice interop library (http://netoffice.codeplex.com) ? he?s added an extra reference tracking layer, and it also allow you to target all Excel versions.







The other question is about some Excel add-in that is related to the book. For almost all Excel add-ins implemented with .NET, and *always* when making user-defined functions, Excel-DNA is the best approach. All versions of Excel are supported. ?Automation add-ins? are a poor approach ? I also started there, but it looks easy in the beginning and then just gets worse and worse.

"