+ Reply to Thread
Results 1 to 7 of 7

Use API to edit registry keys to remove Add-In from Add-Ins List

  1. #1
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Use API to edit registry keys to remove Add-In from Add-Ins List

    The thread title says it all.

    Below are the objectives I would like the solution to meet:

    I want to programmatically remove an Add-In from the Add-Ins list (This is not the same as uninstalling an add-in from the list).

    I do not want to have to close Excel as part of the solution.

    The removal can be achieved by finding & removing the registry key for the Add-In. (I think an .ini file may need to be refreshed as well - seeing as how Excel updates the registry when the Application is closed)

    I would prefer the registry editing to be done by API rather than WScript.
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************

  2. #2
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Use API to edit registry keys to remove Add-In from Add-Ins List

    This may help http://answers.microsoft.com/en-us/o...4-66a08e4b62ac

    This link contains code which almost achieves what I want - except it relies on closing Excel application and I'd prefer to use API rather than WScript.

  3. #3
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Use API to edit registry keys to remove Add-In from Add-Ins List

    Leaving aside the API outcome for now, would it be possible to alter the code in post#2 so that Excel doesn't need to be closed to remove the add-in from the list?

    Also, can anybody explain where/what Excel writes as it closes? (It writes certain values to the registry. Anything else? I've heard of a .ini changing?)

  4. #4
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Use API to edit registry keys to remove Add-In from Add-Ins List

    I found some code on the net to INSTALL an addin using registry keys. So I am trying to convert this code to VBA (and from there to UNINSTALL instead of INSTALL). However I am floundering.

    Anyone care to provide a few clues?

    Please Login or Register  to view this content.

  5. #5
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Use API to edit registry keys to remove Add-In from Add-Ins List

    Current version below. I am floundering badly. Anyone skilled with using VBA/API to edit the Registry and/or can assist with what Excel does before closing?

    Please Login or Register  to view this content.
    Last edited by mc84excel; 08-12-2013 at 07:56 PM.

  6. #6
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Use API to edit registry keys to remove Add-In from Add-Ins List

    Does anyone know of a webpage covering indepth what Excel does when it closes? (i.e. where it writes to/saves its settings, what registry keys, what .ini files if any)

    If so, please post a URL! If the page is useful, I'll rep you!

  7. #7
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Use API to edit registry keys to remove Add-In from Add-Ins List

    The add-in names appear in the registry here: HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options (This location will vary depending on your Office version)

    I need a way to loop through the key to find a matching value.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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