Adding a namespace to ExcelDna function for compatibility with VSTO

Nov 18, 2014 at 1:36 PM
I am attempting to replace a VSTO add-in with an Excel DNA add-in. I am having an issue that when a file is saved with either of the plug-ins activated, the other can not read the functions due to VSTO applying a namespace.

e.g. from the sheet1.xml in a saved file
VSTO - <c r="D8"><f>_xll.namespace.func("param")
ExcelDna - <c r="D8"><f>_xll.func("param")

I can not remove the namespace from the VSTO so can I add the namespace to ExcelDNA?
Nov 28, 2014 at 6:47 PM
We have no control over the namespace part in the Excel file. For all .xll add-in UDFs, it seems Excel just stores _xll.

When opening a file that has the old UDF names, you can do a Search-and-Replace for "=" with "=" to get all formulae to refresh properly.