Search code examples
excel-dna

how to convert user input to string in Excel-DNA


Is it possible to call function without including " in parameter for a string param in Excel-DNA


Solution

  • No. Excel interprets the formula before calling the Excel-DNA add-in, and if you don't have the quotes Excel will try to interpret the parameter as a name (names include ranges, names added in the Name Manager etc).

    Why is this an issue for you - it is consistent with how Excel works otherwise?