I have a function that takes an array of strings:
[ExcelFunction("Update", Category = BaseApi.ExcelFunctionCategory)]
public static object MAUpdate([ExcelArgument(Name = "attributes", Description = "The list of attributes to set")] object attributes,
[ExcelArgument(Name = "values", Description = "The list of values of the attributes")] object values)
I am trying to call this from VBA like this:
dim attrs() as string
dim values() as string
result = MAUpdate(attrs, values)
this works fine except when one of the fields in the values array exceeds a certain size - it looks to be 32767.
The string limit in both VBA and C# is 2^31 (> 2 billion) so it looks like there is a problem inside Excel DNA.
I wrote a function in VBA taking the same params and that does not have any problem.
Also, if I put a breakpoint in the C# function on the first line of code, it never hits it.
The error reported is:
1004: Application-defined or object-defined error
any help greatly appreciated.