+ Reply to Thread
Results 1 to 3 of 3

xlm udf registration

  1. #1
    ntoze
    Guest

    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


  2. #2
    ntoze
    Guest

    Re: xlm udf registration

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

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


  3. #3
    ntoze
    Guest

    Re: 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...


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1