Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Mar 2002
    Location
    Sunnvyale, California, USA
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Finding path to Add-ins (Excel 2000 on NT)

    Hi,
    I'm trying to find the path to the default Add-in files. On my machine it is C:WINNTProfileseearnstApplication DataMicrosoftAddIns. I searched the registry but only found this string in the recently used files entries. Excel seems to know it since it defaults to this directory when you browse for Add-ins.

    Thanks,
    Eric

  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: Finding path to Add-ins (Excel 2000 on NT)

    Depends on how these are set when Excel is installed, and what version. On my Windows 2000 Office 2000 which is failry default:

    C:Program FilesMicrosoft OfficeOfficeLIBRARY

    and user library is

    Cocuments and Settings<username>Application DataMicrosoftAddIns

    In VBA use:

    Application.LibraryPath

    and

    Application.UserLibraryPath
    -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: Finding path to Add-ins (Excel 2000 on NT)

    You could try

    Application.LibraryPath

    Note that AddIns will function without problem even if they are not installed to the default AddIn folder, provided of course that are stored on the local system.

    Andrew C

  4. #4
    Lounger
    Join Date
    Mar 2002
    Location
    Sunnvyale, California, USA
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Finding path to Add-ins (Excel 2000 on NT)

    Hi,
    Thanks to both of you, UserLibraryPath gave me what I was looking for.

    Thanks again,
    Eric

Posting Permissions

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