Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    include formula from add-in? (2k, 2003)

    I have a workbook which gets distributed to others. It contains one instance of the numbers-to-words (=NBtext) formula from Laurent Longre's morefunc add-in.
    It only does its job (obviously) if the target also has morefunc installed and enabled, which most haven't.
    Is there any way of 'packaging' this formula in my workbook, so that it always works (provided the user has Excel, or Open Office.)
    If not, it's not a show-stopper, just a minor irritation.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: include formula from add-in? (2k, 2003)

    The code from the Morefunc add-in is not available, so you cannot incorporate it in your workbook. Either let all users install Morefunc, or avoid using it and use another number-to-words function - see for example the thread starting at <post:=507,695>post 507,695</post:> or <post:=177,341>post 177,341</post:>.

  3. #3
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: include formula from add-in? (2k, 2003)

    Thanks v much, Hans.
    Will do Legare's trick.
    So, thanks to Legare, too.

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: include formula from add-in? (2k, 2003)

    You're Welcome. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Legare Coleman

Posting Permissions

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