Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Wanted - Recap of add-in functions (Excel 2K SR1a)

    I am interested in getting a list of all of the different functions that each standard (Office-installed) add-in has. Also, is there a way to extract certain desired functions from an add-in without loading the entire module?

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Wanted - Recap of add-in functions (Excel 2K SR1a)

    My add-ins are sufficiently numerous that I can't be sure, but I think the answer is "none", except there may be some UDF's in the standard add-ins which are intended to serve just those add-ins. Andrew Cronnolly pointed out a while back that a number of built-in Functions are dumped into the User-Defined category, which can be confusing.

    If you install the Analysis Toolpak from MS, then you get a host of additional Functions, which can be identified by looking in Help for "Analysis Toolpak".

    I believe the answer to your second question is no.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Wanted - Recap of add-in functions (Excel 2K SR1a)

    David,

    If you do not have any documentation for your Add Ins, the VBE Object Browser might offer some help. If you select the Add In you are interested in in the Project Explorer and then select the appropriate file (library) in the top drop down list. See attached screen image (compressed a little), with atpvbaen.xla (Analysis Toolpak) as the example.

    As these AddIns are protected you cannot access individual functions to include in a custom add-in. I think the Analysis toolpak is the only general purpose add-in included with the Office installation. Others tend to very specialist and might only have one or two functions/subs.

    Andrew C
    Attached Images Attached Images

Posting Permissions

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