xlm udf registration
 

Hi,

I'm trying to use the xlm udf registration method from chapter 5 of the
book "Professional Excel Development". It works for 2 argument
functions, but I can't get it to work for functions with more than two
arguments. I just get a #Value! error. Has anyone else encountered this
problem?

I'm using Excel 2003 SP2.

e.g. I add an extra argument to the 'IFERROR' function in the
MFunctions module, then add one to lNumArgs in the MRegister module and
add an extra name to the argument names and an extra argument
description.


Thanks,
Nick

xlm udf registration
 

I've found this alternative version which works for me:

http://www.jkp-ads.com/Articles/RegisterUDF00.htm

xlm udf registration
 

It appears that for Excel 2003 sp2, this xlm registration method
doesn't avoid the hardcoded workbook links, contrary to what is said on
page 120 of 'Professional Excel Development'. Nuts...