Solved

VB.net Excel add-in re-enable programatically

Posted on 2015-01-04
3
481 Views
Last Modified: 2015-01-05
Hi

Is it possible to re-enable a VB.net Excel add-in that has been disabled?

Thanks
0
Comment
Question by:murbro
3 Comments
 
LVL 4

Assisted Solution

by:jimtech
jimtech earned 250 total points
ID: 40530429
Not sure if this would work for you but you can try this:

Automation Add-Ins are loaded in the same way as normal .xla Add-Ins , but using the ProgID instead of the file name, as in the following code:

Sub installAutomationAddIn()
    AddIns.Add Filename:="Excel2007ProgRef.Simple"
    AddIns("Excel2007ProgRef.Simple").Installed = True
End Sub

If you are creating an installation routinefor your Add-In, you may want to write directly to the registry in order to set the Automation Add-In as installed. To do so, you need to create the following registry entry (Which will already exist if you've used the above code).

(In the Registry Key:)
HKEY_CURRENT_USER\SOftware\Microsoft\Office\12.0\Excel\Options

(Create the string value:)
Name = the first unused item in the series: Open, Open1, Open2, etc.
Value = /A "Excel2007ProgRef.Simple"
0
 
LVL 9

Accepted Solution

by:
Christopher Jay Wolff earned 250 total points
ID: 40530435
Probably need to know what version of Excel as things are moving to XML.. There is a thread here below

http://answers.microsoft.com/en-us/office/forum/office_2007-customize/remove-an-excel-2007-addin-programatically-in-vba/2fffffdf-dfc9-4723-8924-66a08e4b62ac

that discusses testing status and turning add-in on and off with VB.  Older versions of Excel you could reset the registry keys, as described here

http://support.microsoft.com/kb/291392

Please let us know if this applies to you or if not, what version you have.
0
 

Author Closing Comment

by:murbro
ID: 40531389
Thanks very much
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question