I am new to Excel-DNA and working through the Getting Started actions. The sample AddThem function with code in the dna file works fine and when I open Excel and type =AddThem(2,5) I get the expected result of 7 and the function displays in
the context help as I type. I can build the example MultiplyThem dll using c# and it similarly behaves as expected. However, when I build the dll using
VB.Net I cannot get the function to appear in the context help as I type and I receive the #NAME? error in the cell. I have used the steps discussed in the Patrick O'Beirne "VBA to
VB.Net XLL add-ins with Excel-Dna" tutorial without success. We have a bunch of VB6 function libraries deployed as dll's that need migration to .Net. Development environment is Win7-64, VS 2010 and 32-bit Excel 2010.
Thanks for any suggestions.