0

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

user1618820
  • 109
  • 1
  • 2
  • 11

1 Answers1

1

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?

Govert
  • 16,387
  • 4
  • 60
  • 70
  • Thanks for the reply .This is required since I am developing an excel add in for elastic search and user may happy to type for example getContent(africa,18-07-2012,04-09-2012)rather than getContent("africa","18-07-2012 00:00:00","04-09-2012 09:53:26") right? – user1618820 Sep 26 '12 at 11:04