COM Interop for SimMetrics .Net

  • SteveT

    SteveT - 2006-08-24


    I had need to use the SimMetric Levenshtein Distance Metric in Excel to determine the closest match in a group of cells to a another cell value, but .Net components cannot be used directly in Excel VBA because they are not COM components.
    I created a .Net wrapper project around SimMetrics that exposed the Levenshtein (only) metric function. I also created an Excel Add-in that used the wrapper so it was available as an Excel UDF (User Defined Function).
    All of this works fine, so my question really is whether it would be possible for you to create the COM interfaces in the SimMetrics .Net project, eliminating the need for my wrapper. This would allow any COM supporting program (Excel, Word, VBS, AutoIt etc.) to have access to the functions.

    By the way, thanks for the excellent work!

    • Chris Parkinson

      Chris Parkinson - 2006-08-26

      I can add it to the list of things to do.

      thanks for the thanks


    • ReverendSam

      ReverendSam - 2006-10-12

      In case anyone else is interested until things are merged please see


Log in to post a comment.