xlfRegister Failed Error for COM & XLL combined Addin

Add-in Express™ Support Service
That's what is more important than anything else

xlfRegister Failed Error for COM & XLL combined Addin
XLL Registration succeeds for Excel 2007 and above but fails for Excel XP (2002) 
Subscribe
Jim J




Posts: 9
Joined: 2019-03-26
Hi Andrei,

Thanks, the new version of Add-In Express does fix the exception that occurs when loading an xll add-in that contains a user defined function with over 20 parameter descriptions in Excel versions 2002 (XP) and 2003.

However, I did notice some strange behavior and was wondering whether it is an Excel XLL bug or an Add-In Express bug. When I created a test function that had 30 parameters with generic parameter descriptions of Argument 1, Argument 2, ... Argument 30, and then loaded the test add-in in Excel 2002 or 2003 I expected to see the first 20 parameter descriptions and then the next 10 parameters 21-30 would be blank but instead parameters 21-30 had parameter 2's description of Argument 2 repeated for each of the last 10 parameters.

I can send a simple test add-in demonstrating this behavior if necessary.

Can you look into this, it is not a severe bug but if it can be fixed that would be great, if it is a Microsoft bug than there is probably nothing that can be done so I'll just ignore it.

Thanks,
Jim
Posted 24 Jun, 2019 12:24:38 Top
Andrei Smolin


Add-in Express team


Posts: 16312
Joined: 2006-05-11
Hello Jim,

I've created an XLL function providing 30 arguments.

Although Add-in Express registers this function and although the Excel 2003 Function wizard allows entering the 30th argument, entering this formula: =MyFunc(0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29) produces "Too many arguments". So, I've cut out the last argument *in the formula* and this works exactly as you described:
- arg0: Description="Argument 0"
- arg1: Description="Argument 1"
- arg2: Description="Argument 1"
...
- arg28: Description="Argument 1"

Then I've cut out the last parameter in the XLL function:
- arg0: Description="Argument 0"
- arg1: Description="Argument 1"
- arg2: Description="Argument 2"
...
- arg18: Description="Argument 18"
- arg19: Description="Argument 1"
...
- arg28: Description="Argument 1"

Finally, I modified the descriptions as shown below and got the same picture:
- arg0: Description="Arg 0"
- arg1: Description="Arg 1"
- arg2: Description="Arg 2"
...
- arg18: Description="Arg 18"
- arg19: Description="Arg 1"
...
- arg28: Description="Arg 1"

It doesn't change if I cut out one more parameter of the function.

I think these experiments show that the issue belongs to Excel.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 26 Jun, 2019 09:01:42 Top
Jim J




Posts: 9
Joined: 2019-03-26
Thanks for the quick reply Andrei.

Now that you confirmed this is an Excel bug I will file it for my records.

Thanks,
Jim
Posted 26 Jun, 2019 11:59:44 Top
Andrei Smolin


Add-in Express team


Posts: 16312
Joined: 2006-05-11
You are welcome!

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 27 Jun, 2019 02:43:31 Top