Solved

Remote Microsoft Excel Add-in

Posted on 2013-05-30
5
778 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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
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 simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
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…

760 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

23 Experts available now in Live!

Get 1:1 Help Now