Solved

Remote Microsoft Excel Add-in

Posted on 2013-05-30
5
887 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
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…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

734 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