Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    RegKeys - Excel Addins, switches (WinXP, O2003 Excel UK)

    Hi,

    Trying to create a small add-in that checks a users PC for available and installed add-ins. I intend to do it through the registry.

    Looking at HKCUSoftwareMicrosoftOffice11.0ExcelOptions there's a ├Žlot of different formats in the keys there.

    Some of them look like switches, eg. /F <path>, /R <path>, other are plain fully qualified paths and others yet again are just the file name.

    I guess that:
    1. "Just filenames" - are the ones placed in the 'addins' folder pointed to by the system.
    2. "The fully qualified ones" - are registered somehow through a system command??
    3. "The switches" - are ????

    Can any one fill me in on the working mechanism of this part of the registry??

    THX
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

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

    Re: RegKeys - Excel Addins, switches (WinXP, O2003 Excel UK)

    In the first place, you can use Excel VBA without having to go into the registry: the Application.AddIns collection contains all add-ins that are listed in Tools | Add-Ins. If the Installed property of an AddIn is True, the corresponding item is ticked in Tools | Add-Ins...

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: RegKeys - Excel Addins, switches (WinXP, O2003 Excel UK)

    I describe how Excel manages addins in the registry here:

    http://www.jkp-ads.com/Articles/Addi...tupFactory.asp
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: RegKeys - Excel Addins, switches (WinXP, O2003 Excel UK)

    Hi Jan,

    Got a flashback when I re-read your article <img src=/S/bash.gif border=0 alt=bash width=35 height=39> -and I can see that you actually already back in December answered my question <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

    So thank you for the very informative and precise article. All that's left for me now in that respect is to find out the mechanisms of the switches.

    ...and to Hans. I already got a piece of code that handles this through the add-ins collection. But for this particular purpose I'll prefer to do it by means of the registry keys. Thanks for the hint anyway - I'll keep it in mind for another time where it may come in handy / ;o)


    THX both
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

Posting Permissions

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