Solved

Remote Microsoft Excel Add-in

Posted on 2013-05-30
5
810 Views
Last Modified: 2013-07-06
I have an "unsupported" add-in that was loaded to a users computer from Kareo.  When I say unsupported that means that they only support it if the add-in works.

I was able to do a test install onto a system that is running same OS and Save version of Office.

Here is my dilemma --

First it was installed on a system (os / version same as above) incorrectly.

so the add-in show's up in Add-Ins on Excel.  When we try to execute any of the add-in menu driven commands it fails says cannot find kareo%20...blah blah blah.xls maybe is has been removed or deleted.

So on the test system the add-in was added successfully the correct way, and it works.  On the system with the problem we attempted to re-add the add-in from a general location and went through the setup and all seemed to work the first time.

Now after closing excel and re-opening the add-in appears to be calling the first add-in that was loaded incorrectly.  We get the same error message that we received above.  So my thoughts are somehow I need to completely remove that add-in from previous install ...

I have no references to it in the registry
the only option on excel add-ins is to uncheck the box, but it is the same name as the new add-in and unchecking the box does nothing, still have the add-in menu on the add-in toolbar.

How can I remove this add-in?  

also to get the new add-in to work I had to modify the macros or code from references to DOMDocument to DOMDocument60 (adding 60 to any parts of the code that failed.)  This works well on my test system...  

PS.. I am not a coder so don't understand it 100%

Any help is appreciated.

If my description of problem is bad or incomplete I apologize.  Please feel free to ask me to clarify anything.  I have attached a picture of the error and the menu that show's up in both working and non-working deployment (it's the same in either).
Please help.
kareoError.PNG
kareomenu.PNG
kareomenu2.PNG
0
Comment
Question by:halejr1
  • 3
  • 2
5 Comments
 
LVL 14

Expert Comment

by:Faustulus
ID: 39209771
To remove an add-in from your computer it may be best to delete the file. There is a default location for add-ins. On Excel 2010 it might be C:\Users\[UserName]\AppData\Roaming\Microsoft\Addins. If you don't run Excel 2010 or you don't file your workbook there you can search for the file name on your C-drive. You can also simply open the list of Addins installed on your computer (Developer tab -> Addins), click Browse and Excel will automatically open the default file location.
After you delete the workbook the Add-in will still be listed. Restart Excel. If Excel tries to load it you will be informed that it wasn't found. If not, load it manually from the Add-ins list, where it still appears. Excel will ask you if you wish to delete it. Click yes, and it will be finally gone.
You can use the reverse process to install an Add-in. Place it in the default file location (with the correct extension, xla*), Developer tab -> Addins -> Browse, and select it.
The most important thing is to remember to restart Excel after deleting addin workbooks in the directory before placing files there with the same name, even if the extension is different.
I hope this helps you solve the problem.
0
 
LVL 8

Author Comment

by:halejr1
ID: 39209881
thank you I will try this tonight and if success award you points.
0
 
LVL 8

Author Comment

by:halejr1
ID: 39220374
did not resolve issue.  I have deleted all references to the file including shortcuts... gone as far as searching the registry, etc.  

System still show's the add-in and when selected get the associated error message.

Any other thoughts or idea's?

Thanks.
0
 
LVL 14

Accepted Solution

by:
Faustulus earned 500 total points
ID: 39220567
Did you find the add-in file?
It should be in C:\Users\[UserName]\AppData\Roaming\Microsoft\Addins. There is no need to go into the registry.
Have you located the default file location your Excel setup is using? It should be at the above address but, since you have a problem, it will be better to check it in the way I told you last time:-
You can also simply open the list of Addins installed on your computer (Developer tab -> Addins), click Browse and Excel will automatically open the default file location.
The problem will not go away unless you find and delete the file and then restart Excel.
0
 
LVL 8

Author Closing Comment

by:halejr1
ID: 39304200
this did not solve my issue but was very good advice.  I had to create a new profile and all was good.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

895 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now